Amanda1234
New Member
- Joined
- Oct 12, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I have a Master price file that has multiple columns starting with the product code. I would like another sheet to pick up certain columns when we type in just the code.
ie. Master Sheet - Product code, Supplier, Description, Buy Price, Conversion, Unit Price
New Sheet - Product code typed in brings up Supplier, Description, price all in separate cells.
I have tried vlookup formulas in each cell but it slows the sheet down alot when we copy/paste a handful of codes down column 1 at a time.
ie. Master Sheet - Product code, Supplier, Description, Buy Price, Conversion, Unit Price
New Sheet - Product code typed in brings up Supplier, Description, price all in separate cells.
I have tried vlookup formulas in each cell but it slows the sheet down alot when we copy/paste a handful of codes down column 1 at a time.