I have an inventory excel spreadsheet with about 2000 items in it. I use my own part numbers, item description, price, last date price was updated, and company purchased from.
To this point I would use the excel find feature and update pricing, date of price change that way.
I am trying to update the pricing by searching with my part number.
I have a new worksheet which has 3 lines.
Part number, item, price.
I would like to enter my part number, excel lists the item and current price. If I need to change the price I can change there and it changes it in my inventory. Right now I am using Vlookup to display the info now. Takes too long. My dilemma is changing the price and it changes the price in my inventory worksheet.
If possible I would also like to change the date on which I am making the change.
Thanks in advance.
Bookmarks