VBA - One sheet to become many based on one variable

Hi all

I have toiled and toiled with this hence the name I chose.

Basically I produce an excel sheet each month, in column A is a Id, this Id can be repeated for several rows (varies) - what I need to do is create new workbooks for each Id and pull the data from the original table through too, so create new work books based on that Id and the corresponding info

I could do filters etc for each of the known Ids (about 127) and then copy this into a new sheet but it would be messy and very rough code based on recording and trial and error

I found this code which can create new workbooks for each of the Ids,

can anyone help pulling through the data? at the moment its populating the field names only from the top of the document

Please Login or Register  to view this content.

Thanks guys, would help me a lot

Hi fortheloveofgod and welcome to the forum. I am going to change your tags to be code tags instead of quote tags and I would ask that you use code tags in the future (for code examples). You could type in the tags by using the following example
[CODE]Sub YourCode()[/CODE]

Thanks!

here's some basic code that should work for you with some slight tweaking to suit.

Please Login or Register  to view this content.