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!