Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D reference question in inventory Worksheet
I have a Master Inventory Worksheet that has the Description and the
Packaging on the same row as product number and price for each of 3 Vendors (A, B, and C). I want to create a 3D reference to create a linked Vendor Worksheet containing the Description, the Packaging (which is the same for all vendors) and only Vendor A's product number and price and another with Vendor B's produce number and price and another with Vendor C's product number and price. The end result is when Vendor B sends me (let's say by e-mail) new prices, product numbers and descriptions, the Master Inventory Sheet reflects it in real time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inventory Spreadsheet Question | Excel Worksheet Functions | |||
I am looking for an excell worksheet for restaurant inventory | Charts and Charting in Excel | |||
Creating an inventory worksheet | Excel Discussion (Misc queries) | |||
how do i set up a worksheet to calculate the inventory? | Excel Worksheet Functions | |||
Inventory List Question | Excel Discussion (Misc queries) |