ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to display selected table entries from another worksheet? (https://www.excelbanter.com/excel-worksheet-functions/48442-how-display-selected-table-entries-another-worksheet.html)

Wheel

How to display selected table entries from another worksheet?
 
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.


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com