Brooks70459
New Member
- Joined
- Jun 25, 2009
- Messages
- 43
I would like to either auto create or edit names of worksheets in a workbook based on values (names) contained in a column on the first worksheet.
I am using the first sheet in a workbook as an index. This is an index of ten subsequent worksheets. (there will be many more actually created)
At a minimum, On the index sheet I have a list of sub assemlies begining in b2 thru b10. These will be the tab names I need to auto create.
If this works, then I would like to extend the complexity of the function where, I would like to parse the values column test the values in an exisitng worksheet tab.
I would like the function to go down a list and rename the existing tabs based on the values found on the list, then delete all extra tabs right of the last tab evaluated by the list.
Lastly, if this works(a challenge ) , I would like to autocreate hyperlinks, connecting the values index to their respective tab. (wishful thinking I'll bet .)
I am using the first sheet in a workbook as an index. This is an index of ten subsequent worksheets. (there will be many more actually created)
At a minimum, On the index sheet I have a list of sub assemlies begining in b2 thru b10. These will be the tab names I need to auto create.
If this works, then I would like to extend the complexity of the function where, I would like to parse the values column test the values in an exisitng worksheet tab.
I would like the function to go down a list and rename the existing tabs based on the values found on the list, then delete all extra tabs right of the last tab evaluated by the list.
Lastly, if this works(a challenge ) , I would like to autocreate hyperlinks, connecting the values index to their respective tab. (wishful thinking I'll bet .)