Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there a way to easily reference sheet names.
Here is my problem: i have several sheets named 01,02,03,04... and so on, I have a summary sheet that i would like to reference all the individual sheets. I start at the top and refernce sheet 01, then i would like to drag down so that the next row is referencing sheet 02 and so on. This does not happen when i drag the cell down. Is there any way to achieve this. I tried typing out the cell names in another column and referencing that cell inside the ' ', but that didn't seem to work. Thanks, Pat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofilling Sheet Name in Formula | Excel Discussion (Misc queries) | |||
formula referencing a column - autofilling in a row ??? | Excel Discussion (Misc queries) | |||
Referencing Sheet Names | New Users to Excel | |||
copy formula referencing sheet name to another sheet | Excel Worksheet Functions | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions |