I currently have a table that has alllll of our data. We want to separate it so it's a bit easier to manage. So, here's what I'm trying to do:
Tab 1 - Master Info. This will have a SKU#, a product name, and a materials cost.
Tab 2 - Wholesale Vendor #1 - We will type in a SKU, and it will bring in the product name and materials cost from Tab 1.
Tab 3 - Wholesale Vendor #2 - We will type in a SKU, and again, it will bring in the info from Tab 1.
I don't want the tabs to be busy and have extra columns. I'd like it to be a basic "vlookup" type. However, I can't figure out how to do it without a) having the extra columns and b), going into each and every line to pull out the info.
Any tips? Thank you!
