Code to insert Worksheet before a specific worksheet in a workbook

Hi All

I have a userform which creates a worksheet from a template sheet and renames it based on the on the Class field in that form.
It places that sheet before Sheet 26 but this sheet number seems to change after the New Sheet is added.
I would like a macro to be able to insert the new sheet after the last J** sheet each time so the J* sheet run in sequence.

Please Login or Register  to view this content.

I have a second issue in that I need the code to also place the info from the Class field and place it in the first free space in the Menu Sheet after the last J** and then create a hyperlink to that sheet.

Any help would be appreciated.

Thanks in advance.

Tony

Thanks Mike

i can't believe I overlook the simple solution to that.

Do you have any ideas on the second part of my problem.

Thanks

Tony