Copy paste to other sheets

[govi]

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!

 

[Luke M]

Check this out:

http://www.rondebruin.nl/copy5_2.htm