Hi all,
I would like to create a list for the 30 worksheets in the workbook and have the worksheet names update according to the list, i.e;
A1 = Worksheet1
A2 = Worksheet2
etc.
This list will change on at least a weekly basis, and I would like the worksheet names to reflect this.
I can see how VBA would be used, but is it possible to do this with standard functions as Macro's and script are disabled due to security policy.
WHY do I need this You ask....
I have a complex workbook with 30+ worksheets which are consolidated from external files. Each worksheet refers to a current required process name, and these change from version to version depending on which of the 100+ processes are used for this workbook version.
Provisioning 100+ worksheets is not practicle for user, but using a text based translation table, has also been challenging for them as navigation between the tabs is key for usage.
I would like to create a list for the 30 worksheets in the workbook and have the worksheet names update according to the list, i.e;
A1 = Worksheet1
A2 = Worksheet2
etc.
This list will change on at least a weekly basis, and I would like the worksheet names to reflect this.
I can see how VBA would be used, but is it possible to do this with standard functions as Macro's and script are disabled due to security policy.
WHY do I need this You ask....
I have a complex workbook with 30+ worksheets which are consolidated from external files. Each worksheet refers to a current required process name, and these change from version to version depending on which of the 100+ processes are used for this workbook version.
Provisioning 100+ worksheets is not practicle for user, but using a text based translation table, has also been challenging for them as navigation between the tabs is key for usage.
