Import single cell from several worksheets to new worksheet

P

Prkr

I want to import a single cell (a total) from several different Excel
worksheets into a new single worksheet and put these values in their own
seperate cell in the new worksheet.
 
B

Biff

Hi!

If I understand you correctly you want to "link" the same
cell in several sheets to individual cells on another
sheet?

The cell you want to link to is sheet2!A1,sheet3!A1,sheet4!
A1 etc.

Maybe something like this:

=INDIRECT("sheet"&ROW(2:2)&"!A$1")

And copy down as needed.

Biff
 

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

Update several ppt documents from a single excel file 0
Wotksheets 0
Possible to Combine reports to's to a single box? 0
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Syncing between source worksheet and dependent worksheets 0
fill multi cells with single cell 1
Worksheet Names using Macros 5
Scrubbing two excel worksheets, returning unique values from one sheet 0

Top