Create new sheet from template, auto fill from index sheet and hyperlink

Good Afternoon All,

I'm trying to create a workbook that takes the data from the selected row and creates a new worksheet based on a template sheet with the details from that row. It would also create a hyperlink from that row to the new sheet.

I've seen a couple of similar threads but each one has it's own twist and being rubbish at macros I find them very difficult to edit.

Any help would be greatly appreciated. I've attached the draft workbook for you to see. It has the index page to get the data from, the template page and 'Box 1' is an example of what the sheet would look like completed.

Many thanks in advance for any help!

R

Update

This is what I've got macro wise so far

Please Login or Register  to view this content.

My problem is that I can't find a way to set 'RowNo' as the active cell row from the index sheet. Does anyone know how I can do this? I think if I can set that right then this should work fine. I'd just need to be able to create a hyperlink in Column A of the activerow to the newly created sheet.

Update.

I've managed to get the macro to create the new sheet with the correct name and insert a hyperlink to it. But the hyperlink doesn't work. Not sure if this is because it automatically replaces spaces with %20 (hex or something) Sub Create_sheet()

Please Login or Register  to view this content.

Could maybe use something like this to try stop it, but I have no idea if it would work and no idea how to work it into the code. If anyone knows how to hyperlink this correctly that would be great!

Please Login or Register  to view this content.

Managed to get it working.

Code if anyone needs it.

Please Login or Register  to view this content.