Hi All,
I have got some useful codes for my project to automatically generating worksheets of each individual employee in the active workbook. Please see below codes for the same:
Could you please tell me how to automatically add hyperlinks from each employee's ID to his unique individual worksheet, so whenever we run the above codes for automatically generating the worksheets, then all of those worksheets have a hyperlink form the main worksheet - "Monthly Productivity Data".
For example: If a new sheet is generated with a name as Tom Cruise then a hyperlink should appear on his ID on the main worksheet Monthly Productivity Data. so we can visit his unique worksheet on a simple click.
Workbook: MS Excel 2003
Thanks in advance!
Plz find the attached workbook for more details.
Bookmarks