Hello,
I am new at this and need a bit of help please.
I have an inventory sheet and I get price change updates from time to time..
The inventory is well over 800 products but the price changes are much less.
I was wondering if its possible to match the part numbers from the price change sheet and to the full inventory and change the prices for COST and LIST on the full inventory sheet only affecting the price changed parts.
Any help with this would be greatly appreciated .
The price changes sheet is called PriceChange , the part number is in col A, cost in B, List in C
The full inventory I'd like to change
The sheet is called BulkProductData the part number is in col B, the cost is in col H, list in col I
there are header rows on each sheet
Again thank you for your time!
Bookmarks