Separating data into individual sheets

[excelforum911]

Hello everyone,

To summarize, I have a data sheet of almost 37,000 lines. It is a customer purchases database with around 10 columns.

I need to separate the spreed sheet based on each individual customer (which is located in column G) and put this data onto separate tabs (sheets)

I already did research before hand and tried the code that was posted here on this link. http://www.ozgrid.com/VBA/item-worksheets.htm However, after trying to make it work, the best I could do was have it the company's separated into individual sheets but I couldn't get any of the data to go along with it.

Can someone help me modify the existing code that was provided on the website above to make this work or provide a new one? I have attached a test excel so you guys can see what my document looks like. Any and all help would be greatly appreciated. Thanks again.


-Shawn

[jindon]

Try the attached

[jindon]

Cross post

http://www.ozgrid.com/forum/showthread.php?t=167975

[excelforum911]

jindon- Thank you for the attached file with code. For some reason it kept saying that it was out of the relevant range however when I applied it to my main document. Its no problem though cause my other post got a perfectly working code. I am sorry about that btw. I honestly thought it was two separate sites. Thanks again however for your time.

[jindon]

I don't understand what you are talking about the ERROR.

And the sites are completely different.