Excel 2007 : Worksheet names into cells

**esullivan** · 07-06-2010, 02:03 PM

I want have a list of all the sheets in a workbook except sheet1. So in shhet1, A1 is the name of sheet2 A2 is the sheet3 and so on. Unless the sheet doesn't exsist.

Can this be done without a macro is it's live? I would add a sheet and it would populate in Sheet1 without having to do anything?

**DonkeyOte** · 07-06-2010, 04:26 PM

You can't really do this without VBA in some form I'm afraid (ie Sub, XLM call or 3rd party add-in)

You can return a given sheet name via formulae (in a saved file) using the CELL function, however, getting a list to update dynamically would warrant code in some form or other I'm afraid.

**esullivan** · 07-06-2010, 04:30 PM

Originally Posted by DonkeyOte

You can't really do this without VBA in some form I'm afraid (ie Sub, XLM call or 3rd party add-in)

You can return a given sheet name via formulae (in a saved file) using the CELL function, however, getting a list to update dynamically would warrant code in some form or other I'm afraid.

OK thanks for your help!!