How to display selected table entries from another worksheet?

W

Wheel

I've got a table in one worksheet and would like to display certain fields
from certain entries in another worksheet based on a simple matching criteria.

My example is a list of sold items with a buyer number. I want to make a
receipt that lists just the items for a particular buyer number.

All I really need is to get a colum of item numbers that match a specific
buyer number, then I can look up everything else I need by item number.
Remember, the list has to be generated within the body of my receipt.
 
Top