I am working with two separate data sheets. One lists all the products in one column with pricing usage and vendors in columns next to it. In the new data sheet that I'm creating, I listed all the vendors in separate columns with the part numbers all in column A. I need to show (by highlighting or inserting a character so that I can later highlight) all the products in the list that were bought by a specific vendor. For example, when you scroll to the right, I want the boxes to be highlighted in yellow underneath the vendor in line with the product we've bought from them. The point is to be able to have the vendor re-quote these materials.
Product ID Vendor 1 Vendor 2 Vendor 3 Vendor 4 Vendor 5 Vendor 6 Vendor 7 Vendor 8
Product 1 *
Product 2
Product 3
Product 4 * *
Product 5
Product 6
Product 7 *
Also, in the first data sheet the products may be listed multiple times if they are being bought from more than one vendor.
Something like if on sheet1, E3 is greater than or equal to 0 then enter * in the matching box from sheet 2 Under that vendor across from that product..
This ones really throwing me for a loop.. Thanks in advance!
Product ID Vendor 1 Vendor 2 Vendor 3 Vendor 4 Vendor 5 Vendor 6 Vendor 7 Vendor 8
Product 1 *
Product 2
Product 3
Product 4 * *
Product 5
Product 6
Product 7 *
Also, in the first data sheet the products may be listed multiple times if they are being bought from more than one vendor.
Something like if on sheet1, E3 is greater than or equal to 0 then enter * in the matching box from sheet 2 Under that vendor across from that product..
This ones really throwing me for a loop.. Thanks in advance!
