Import single cell from several worksheets to new worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top