Retrieving Data from Multiple Sheets

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I have a workbook with about 40 sheets. I would like to
extract a couple of cells from each sheet into a summary
sheet. Is there any way to achieve this?
 
Hi Sam

it really depends on what you want to do and how your data is constructed ..
one option is to use the Consolidate functionality on the Data menu.

Might be worth looking at help on.

Cheers
JulieD
 
Hi Sam
what are you exactly trying to achieve :-)
Creating a sum: You may use the formula
=SUM('sheet1:sheet6'!A1:A20)
to sum all cells A1:A20 for the sheets sheet1 to sheet6
 
Back
Top