Worksheet name moved to an Index page.

**eber5266** · 03-18-2013, 07:20 PM

Long time watcher first time user.

I have been working on the problem for a while now and I can not come up with anything. I will try to explain this as best as I can. I have multiple issues I need to work on but will try to get this done first.
I have a workbook with multiple worksheets. One of these worksheets is an index page. It lists all of the pages by name and then has what sheet number it is. Is there a way to automatically populate this index with out entering data manually? Also the number of worksheets may be added to or subtracted from, so there is not set number. Do I need a macro to complete this or can I use a formula?

Thanks

**Tank997** · 03-18-2013, 07:44 PM

See this post, I think it will do what you're asking

List all Worksheet Names Using Formula

Edit: I just tried the first posts formula, on a workbook with 167 sheets and it worked perfectly!!

**eber5266** · 03-18-2013, 10:29 PM

Thank you very much. The formulas did work. I did not get the UDF to work but was wondering if it would update an index page automatically?

Thanks

**Tank997** · 03-18-2013, 10:58 PM

I tested the first formula (=IFERROR(INDEX(SheetNames,ROWS($A$2:A2)),"") ) and it will add new sheet names as you copy it down or if you have the formula in a cell that's returning an error ("") blank, you can hit F2 in any cell on your index sheet the new name(s) will get filled in. I didn't try the UDF since the first solution worked. I found it interesting that you can use old XLM code in a the named range formulas. I had no idea you could do that. I'm sure I can think of some interesting things to try with that.