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