Add new job and hyperlink to corresponding sheet

[electricsec]

I have a userform that creates and fills in a new sheet from a template and fills in a master sheet. I am having issues with the master sheet overwriting the information already there. I would also like the Job Numbers on the master sheet to automatically add a hyperlink to the corresponding sheet.

Here is the code I seem to be having trouble with:

Please Login or Register  to view this content.

[Norie]

What's the problem with the code?

The only thing I can see straight off is this.

Please Login or Register  to view this content.

Worksheet should probably be Worksheets, and even if that change was made there's no Show method for worksheets.

If you want to activate Master after the new job sheet and hyperlink have been created try this.

Please Login or Register  to view this content.

PS Wasn't sure what text you wanted to display for the hyperlink so I just used the new sheet name, ie the job no.

[AlphaFrog]

Please Login or Register  to view this content.

[Trebor76]

Hi electricsec,

Welcome to the forum!!

I'd also say you need to change these lines of code...

Please Login or Register  to view this content.

...to this:

Please Login or Register  to view this content.

That said, I would strongly recommend not having separate tabs for each job but just one template with a drop-down for the jobs that populates each field. It won't take long for the work book to become unmanageable having a separate tab for each job as you're intending. This is a common mistake many people make which we try to discourage users from making.

Regards,

Robert

[electricsec]

Thanks for all of your help. AlphaFrog's code worked great for me.
I love the idea of having a drop-down for the jobs, thanks for the great suggestion.