| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reference tabs in a summary sheet as column headers
I am trying to summarize my data on the last sheet of the workbook.... the
sheet names will change frequently..... so what I am trying to do is have a cell (column header or name) on the summary sheet automatically read the name on each sheet and use it in the cell for my header-- Then when the sheet name changes it will automatically update my summary page... Is this possible? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling rows from tabs to a "summary" sheet | Excel Worksheet Functions | |||
| Summary sheet for 80+ tabs/worksheets | Excel Discussion (Misc queries) | |||
| Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
| How do I reference values from 200 worksheets onto a summary sheet | Excel Discussion (Misc queries) | |||
| Cell reference problems with Summary sheet | Excel Worksheet Functions | |||
Threaded Mode
