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

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

One way to do that is to use a pivot table and sort the entire table by each
vendor. This way you only have to create one pivot table instead of a table
for each vendor.

"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

Hi David

Maybe a filter macro is a option for you
See
http://www.rondebruin.nl/copy5.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"David" wrote in message ...
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

below is a sample of the data already sorted by Vendor and Ticket Number.

S-5267 ________________ 41780 05/21/09 15280 26500
S-5281 ________________ 58080 05/23/09 28600 29480
S-5271 Anderson (Reed) 71340 05/22/09 22680 48660
S-5225 Anderson (Reed) 20540 05/15/09 9840 10700
S-5271 Beta Seed 71340 05/22/09 22680 48660
S-5171 Cascade Farm/Ran 43960 05/05/09 28560 15400
S-5177 Cascade Farm/Ran 53540 05/07/09 32920 20620
S-5185 Cascade Farm/Ran 52160 05/08/09 32900 19260
S-5208 Cascade Farm/Ran 51980 05/12/09 32820 19160
S-5176 Farm Feed/Cattle 80900 05/06/09 37460 43440
S-5188 Farm Feed/Cattle 81140 05/08/09 37180 43960
S-5197 Farm Feed/Cattle 80320 05/10/09 37120 43200
S-5198 Farm Feed/Cattle 78980 05/11/09 37160 41820
S-5204 Farm Feed/Cattle 77540 05/11/09 37100 40440

I hope this helps.

"Shane Devenshire" wrote:

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