|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 9th, 2009, 09:48 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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. 
|
|
#2
November 9th, 2009, 09:52 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.
|
|
#3
November 9th, 2009, 10:50 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.
|
|
#4
November 9th, 2009, 10:55 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
