EwatchesUSA
New Member
- Joined
- Apr 12, 2011
- Messages
- 15
Hello everyone, I have excel wordbook with two sheets in it,Sheet A has all our auto parts, SKU, quantity, purchase date, and Item cost, sheet B contain, SKU, PURCHASE DATE, and Item cost, when we receive new parts we add theme to sheet B and sheet A gets updated automatically, sometimes when we receive new price change we have to look in sheet A one by one for the parts with new price and we change it manually, I'm looking for formula to put in sheet A to pull in the newest price added in sheet B, kEEP IN MIND SHEET B can have the same part number multiple times, I want pull in only the last price update.
Regards Mike
Regards Mike