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.
Last edited by SunOffice; 03-23-2011 at 08:52 PM.
Excelforum is Completely Awesome! True learning with Live Examples & Best Techniques!!
your codes are fantastic, better in all the ways!
Could you please automatically send the relevant data from Monthly Productivity Data worksheet to each employees worksheet. Please check out the attached for an example, so I don't have to copy & paste the values again & again.
Bookmarks