Taxmom,

One way to try it is to simply set up formulas in the ABC Printing
worksheet to copy the main page data if the vendor = "ABC Printing".
You'll have blank spaces but won't have to sort.
A1 formula: =IF(Main!$C1<"ABC Printing",Main!A1,"")
A2 formula: =IF(Main!$C2<"ABC Printing",Main!A2,"")
....
B3 formula: =IF(Main!$C3<"ABC Printing",Main!B3,"")
....
Good luck.
Joe W


taxmom wrote:

Hi,

I have been unsuccessful in trying to figure out a formula that will look at
data in one spreadsheet and post all of the items found into another
worksheet.

example: worksheet 1 contains daily transactions in separate columns:
date vendor ck# amount
1/5/05 abc printing 504 100
1/5/05 sbc telephone 505 100
1/5/05 super coups 506 300
2/7/05 abc printing 507 100
2/8/05 sbc telephone 508 300
2/30/05 abc printing 509 200

I need the abc printing worksheet to be able to pull all of the payment
data; date, ck#, & amount made to them that is listed on the daily
transaction worksheet. Even if it is not in order.

I want to eliminate doing a sort or pivot table everytime we want to look at
how much we have paid someone. I would like it to flow directly on to
another worksheet.

Can this be done?
I would appreciate any help I can get. Thanks