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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing formula using Indirect 4
Excel shortcut options 0
Accessing Other Sheet Tabs from within Excel 2
summary values across worksheets within the same workbook 2
copy data of two cells from Sheet 2 into one cell in Sheet 1 6
Macro for summarizing multiple sheets 1
Formula Based on Multiple Sheets 5
Referencing a named range on another sheet 4

Back
Top