| Home |
| Search |
| Today's Posts |
|
#1
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows to new sheet based cell reference, not value | Excel Discussion (Misc queries) | |||
| Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
| using IF function to copy, but leave populated cell alone | Excel Worksheet Functions | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Threaded Mode
