Auto Create Worksheets from Lists

[TD_struggles]

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.

 

[jolivanes]

Re: Or is one of the many that once they have what they want won't border anymore with the thread.
Change "border" to "bother". But I assume whoever reads it that they know what I mean!!!!

 

[kevin9999]

Re: Or is one of the many that once they have what they want won't border anymore with the thread.
Change "border" to "bother". But I assume whoever reads it that they know what I mean!!!!

I don't know why you bordered to change it

 

[jolivanes]

OK Kevin. This one is on you