Hi,

Might help to show us a sample of the data.

You could apply an autofilter to the vendor column and filter on a
particular vendor as a start.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"David" wrote:

I have a spreadsheet that contains weight tickets for the month of some/all
of my vendors. This information is listed in vertical order with all
references to a specific ticket on the same row. What I need to do is copy
some of the data from each ticket to a sperate worksheet, for each individual
vendor so I can print this information out for each vendor.

Vendors may have none of multiple tickets for each month, in May one vendor
had 38 seperate tickets.

Finding the first occurrence of a specific vendor is easy, however, how do I
create a statement to find the rest of the occurrences for each vendor. Also
the first occurence of a vendor in the list will vary each month depending on
the number of tickets each vendor has.

I appreciate any and all assistance I can get.

Thanks,
David