3D reference question in inventory Worksheet

C

Chef Bob

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top