Transferring data from multiple worksheets to a Summary sheet
=INDIRECT(ROW(A1)&"!$B$6")
Gord Dibben MS Excel MVP
On Mon, 9 Mar 2009 12:11:02 -0700, Bette
wrote:
I want to copy data from the same cell in multiple worksheets and I also want
the ability to update.
To speed up the process of creating the Summary sheet, I want to drag down a
column in the Summary sheet and change the worksheet # but not change the
cell reference , e.g. =('5'!$A$2) allows me to drag and the cell reference
will not change but neither does the worksheet.
Is there something I can attach to the '5' that allows it to change by one
as I drag down?
|