Create a new sheet/tab for each row with hyperlink

Hello,

I am building excel workbooks for each customer with all open order and line details. I was wondering if there was a macro to automate the below process.

1. I first export my data and edit my Cells to look like "Example 1"
2. Create a sheet/tab for each individual Sales Order
3. Create hyperlink from main tab to each individual Sales Order "Example 2"

I am not really concerned about adding the line details to each individual tab. It would certainly nice, but not absolutely necessary.


I really appreciate the help!

Thank you Norie! I will give it a shot and let you know.

Next newbie question: How do I save the module as a macro for future use?

I create this same workbook for each customer almost weekly. I would like to be able to use it throughout all workbooks with the keyboard shortcut (ctrl+shift+t)