darren_mac
New Member
- Joined
- Jan 22, 2014
- Messages
- 1
i have followed advice on these forums for creating an "index" of sheets in my workbook.
Now i need to do 2 things to that list:
1. sort it A-Z
2. import data to the index page in respect of relevant fields for the respective Sheet.
eg, the index shows a hyperlink to a sheet name "ABC". I now want to bring data from "ABC" to the index page.
Is there a similar function to a "vlookup" etc that appies to sheet names, or perhaps I'm not referencing it correctly in my formula.
Now i need to do 2 things to that list:
1. sort it A-Z
2. import data to the index page in respect of relevant fields for the respective Sheet.
eg, the index shows a hyperlink to a sheet name "ABC". I now want to bring data from "ABC" to the index page.
Is there a similar function to a "vlookup" etc that appies to sheet names, or perhaps I'm not referencing it correctly in my formula.
