kungfugecko
New Member
- Joined
- Dec 15, 2021
- Messages
- 3
- Office Version
- 2013
I have a workbook with multiple sheets, such as this:
and I am using a VBA code to create a dynamic index page which will list all new sheets added:
The 'First' and 'Last' sheets will always be present in this workbook, and all new sheets will be placed between these sheets. Is there a formula to create a list of all values (names in this case) that are present between 'First' and 'Last' on this dynamic list? so I would like to have a formula to output a list of just:
Abby Alkatraz
Billy Bob
Crazy Chris
Thanks in advance
and I am using a VBA code to create a dynamic index page which will list all new sheets added:
The 'First' and 'Last' sheets will always be present in this workbook, and all new sheets will be placed between these sheets. Is there a formula to create a list of all values (names in this case) that are present between 'First' and 'Last' on this dynamic list? so I would like to have a formula to output a list of just:
Abby Alkatraz
Billy Bob
Crazy Chris
Thanks in advance