ahmed_k
03-03-2010, 01:58 PM
Hi,
I have this workbook where the users can create a worksheet for each location. The new location worksheet is a copy of a hidden worksheet called Location(0). The user should be able to create as many new location worksheets as possible. The new worksheets will have Location(1), Location(2), Location(3) ...... as sheet names. On each new sheet the user enters a location description.
On the title page there is a dropdown which I would like to be populated by the location descriptions as each new location is created. When the user selects the location from the dropdown he should be taken to that sheet.
Alternatively if this is can't be done by a dropdown, a list with hyperlinks should work as well. I tried the hyperlinks myself but was unable to write a macro so that it could create a hypeprlinks for new sheets that are created.
Any help would be greatly appreciated. I have attached an Excel file with the necessary information as an example.
Thanks in advance :friends:
I have this workbook where the users can create a worksheet for each location. The new location worksheet is a copy of a hidden worksheet called Location(0). The user should be able to create as many new location worksheets as possible. The new worksheets will have Location(1), Location(2), Location(3) ...... as sheet names. On each new sheet the user enters a location description.
On the title page there is a dropdown which I would like to be populated by the location descriptions as each new location is created. When the user selects the location from the dropdown he should be taken to that sheet.
Alternatively if this is can't be done by a dropdown, a list with hyperlinks should work as well. I tried the hyperlinks myself but was unable to write a macro so that it could create a hypeprlinks for new sheets that are created.
Any help would be greatly appreciated. I have attached an Excel file with the necessary information as an example.
Thanks in advance :friends: