Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you link a worksheet name into a cell?
I have read through a lot of the suggestions and it seems most are for having
an active worksheet name in a cell. I would like to have lets say 24 cells on ONE worksheet give me the names of the following 24 worksheets or the other way around where the 24 worksheet names reflect the 24 cells on the separate worksheet. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you link a worksheet name into a cell?
You can create a table of contents for an XL workbook with a macro.
See here for more info: http://www.mvps.org/dmcritchie/excel/buildtoc.htm Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Brent" wrote: I have read through a lot of the suggestions and it seems most are for having an active worksheet name in a cell. I would like to have lets say 24 cells on ONE worksheet give me the names of the following 24 worksheets or the other way around where the 24 worksheet names reflect the 24 cells on the separate worksheet. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
Why can't I link a cell from worksheet to another when it has an . | Excel Worksheet Functions | |||
How do I link the worksheet tab to a cell in the worksheet? | Excel Worksheet Functions | |||
Why am I unable to link a cell in one worksheet to a cell in anot. | Excel Discussion (Misc queries) | |||
Can I link a cell to reflect a worksheet name? | Excel Discussion (Misc queries) |