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? |
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? |
All times are GMT +1. The time now is 11:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com