Copy Sheet #'s, but leave cell reference
 

Hey ya'll.

I have a summary sheet that is referencing the same cell, on several
different sheets. The sheets are numbered 'Sheet1', 'Sheet2', 'Sheet3', etc.

On my summary sheet, I want to populate in a column going down, the
following values: Sheet1!$A$2
Sheet2!$A$2
Sheet3!$A$2
etc.

I have about 350 sheets and need the same 5 cells on each of the sheets to
populate to the summary sheet. So knowing how to do this would be extremely
helpful
--
Nothing in life is ever easy - just get used to that fact.

Copy Sheet #'s, but leave cell reference
 

=INDIRECT("Sheet"&ROW(A1)&"!$A$2")

Should get it for you.

"KennyD" wrote:

Hey ya'll.

I have a summary sheet that is referencing the same cell, on several
different sheets. The sheets are numbered 'Sheet1', 'Sheet2', 'Sheet3', etc.

On my summary sheet, I want to populate in a column going down, the
following values: Sheet1!$A$2
Sheet2!$A$2
Sheet3!$A$2
etc.

I have about 350 sheets and need the same 5 cells on each of the sheets to
populate to the summary sheet. So knowing how to do this would be extremely
helpful
--
Nothing in life is ever easy - just get used to that fact.

Copy Sheet #'s, but leave cell reference
 

Worked like a charm. Thank you.
--
Nothing in life is ever easy - just get used to that fact.


"Sean Timmons" wrote:

=INDIRECT("Sheet"&ROW(A1)&"!$A$2")

Should get it for you.

"KennyD" wrote:

Hey ya'll.

I have a summary sheet that is referencing the same cell, on several
different sheets. The sheets are numbered 'Sheet1', 'Sheet2', 'Sheet3', etc.

On my summary sheet, I want to populate in a column going down, the
following values: Sheet1!$A$2
Sheet2!$A$2
Sheet3!$A$2
etc.

I have about 350 sheets and need the same 5 cells on each of the sheets to
populate to the summary sheet. So knowing how to do this would be extremely
helpful
--
Nothing in life is ever easy - just get used to that fact.

Copy Sheet #'s, but leave cell reference
 

Entered in A1 of Summary sheet.

=INDIRECT("Sheet" & (ROW()) & "!A2")

Copy down to A350

I'll let you figure out how to populate the other 4 cells from each sheet.


Gord Dibben MS Excel MVP


On Mon, 9 Nov 2009 13:48:01 -0800, KennyD
wrote:

Hey ya'll.

I have a summary sheet that is referencing the same cell, on several
different sheets. The sheets are numbered 'Sheet1', 'Sheet2', 'Sheet3', etc.

On my summary sheet, I want to populate in a column going down, the
following values: Sheet1!$A$2
Sheet2!$A$2
Sheet3!$A$2
etc.

I have about 350 sheets and need the same 5 cells on each of the sheets to
populate to the summary sheet. So knowing how to do this would be extremely
helpful