TD_struggles
New Member
- Joined
- Oct 17, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi,
I have a tab "Sheet1" complete with lists of all the information I require listed under headings.
I would like a Macro that creates new worksheets for Everything listed in "Sheet1"
The macro would select everything B5 to I82
Create a new worksheet for each cell
Name the worksheet the cell contents
Hyperlink everything in "Sheet1" to its new worksheet
I think i have explained it properly. I've tried a few variations with no success.
I have a tab "Sheet1" complete with lists of all the information I require listed under headings.
I would like a Macro that creates new worksheets for Everything listed in "Sheet1"
The macro would select everything B5 to I82
Create a new worksheet for each cell
Name the worksheet the cell contents
Hyperlink everything in "Sheet1" to its new worksheet
I think i have explained it properly. I've tried a few variations with no success.