Hi,
Ended up rewriting code rather than go through what was already there.
This will work it's way down column B and copy the contents of the entire row to a new sheet called "Heat_x" depending on the value in column B.
I advise you make sure only the Worksheet "Data List" is present befroe running it (i.e. delete Sheets 2 and 3 if present).
Is this doing pretty much what you require? If you need anything more post back.
Note - This could also be handy whilst you're testing this----
If you want to get back to just having your data list sheet after having generated 100+ sheets that you don't want (happened to my whilst developing this
) then use the following code to do it quickly (though ensure Data List is worksheet 1!!)
Tris
Bookmarks