K
KennyD
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
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