• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy paste to other sheets

govi

Member
I have a sheet with 3 Columns:

Column 1: company names(sorted)

Column 2: product

Column 3: sales


I'm looking for a macro that copies the records from the same company to the corresponding sheets(comp1 goes to sheet comp1, comp2 goes to sheet comp2, etc)


Can anyone help?


I have included a example file:

http://dl.dropbox.com/u/12607909/example.xls


Thanks!
 
Top