Macro to create and populate sheets

[GLewis14]

Hi all,

Would greatly appreciate anyone who can, with the attached file, create a Macro (?) that can
- If there is data in a row in sheet “data”
o Create a new sheet, with the title of that sheet equalling the value in Column E
o Putting the values into the newly created sheet from the Data sheet
 I have coloured coded which should translate into which
 I have created an example in the sheet “5555”
Many thanks
Gareth

[Mumps1]

Can there be multiple occurrences of "5555" in column E?

[GLewis14]

yes, and a seperate sheet would need creating for each occurrence.
Thanks

[Mumps1]

Since there cannot be more than one sheet with the same name, how do you want to name the sheet for each occurrence of "5555"?

[GLewis14]

sorry I should have been more clear; there will be multilple entries into column E but none of the entires will be duplicates (i.e. 5555, 5432, 5114 etc)

[Mumps1]

Try:

Please Login or Register  to view this content.

[GLewis14]

thank you -worked perfectly

[Mumps1]

You are very welcome.