Hi there ... new to the forum and have been pulling my hair out with trying to find a solution. Here is what I am trying to accomplish. I have data on page 1 of a workbook. Column B has reoccurring values ... several rows contain the same value ... example below is my page 1.

A B C D
1 6557 AAA 06/14/12 AAA Club
2 6557 ALF 05/04/12 Safe Drivers
3 Q ALF 05/08/12 Franks Auto
4 6557 AM 03/27/12 Hyundai
5 6557 AM 12/06/12 Hyundai
6 6557 AM 11/02/12 O'Reilly Auto Parts

I wanted to copy all of the data from the rows on page 1 to another page based on the value in column B.

What is the best way of doing this ???

Thanks for any help you can offer.

DC