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.
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.