VB code to autodump data into separate pages of excel

[billyheanue]

Hi all,

I would like to have conditional code that, depending on a value (Buyer mnemonic ID) in column G, grab all of the same ID's, and dump the lines into his/her own page. And so on, with each unique ID...take all of their lines, and put each buyer's respective lines into their own Excel page.

Could anyone help me out with this? Is there a limit on how many pages can be created within the same book? I have 30 different buyer IDs.

Thanks!
Bill

 

[hiker95]

billyheanue,

So that we can get it right on the first try, can we see what your raw data worksheet (with titles) looks like?


See reply #2 at the next link, if you want to show small screenshots.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheet to the following free site (sensitive data changed), and provide us with a link to your workbook:

https://dropbox.com