Macro to create Hyperlinks of a new page

[digixu]

Hi i am pretty new to excel and i am propably way in over my head any help would be appriacted, ok i've made a payroll system our staff the front page lists all the staff down with the first name at A8 and the last employee at A18 the worksheet is called home


ive created a macro to create a new employee it copies the master sheet, goes to home inserts a line under the last employee types in rename employee here copies some of the forumlas and what i am trying to get it to do is to create a hyperlink that links to that new page i created problem is it works first time but the second time the macro is pressed it links the new new employee to the old emp

Please Login or Register  to view this content.

[JBeaucaire]

The goal is to NAME each sheet uniquely to match the name of the cleaner being added, that makes it easy to match:

Please Login or Register  to view this content.

[digixu]

Thank you so much it works perfectly.