Home > Forum Home > Analyzing Corporate Financial Data > Price updating Share

Price updating

Excel Help for Price Updating in Analyzing Corporate Financial Data

Forum TopicPost Reply Login

Price Updating

Rate this:
(3/5 from 1 vote)
ConfusedHi everyone
Please can someone help me with probably a simple script that can do the following.
I have one master spreadsheet full of product numbers and prices. The products are from different suppliers and all mixed up. Every year the suppliers change their prices and I need to import the new prices from suppliers spreadsheets.Once I have done this I can then import my master spreadsheet back into our accounting package.
The ideal script would look at the part number in each row of column A in spreadsheet 1 (the master spreadsheet) and look for a matching part number in spreadsheet 2 (the new price list). If it finds a match then copy the price from column B in spreadsheet 2 over to column B in spreadsheet 1. The script would continue this process until all populated rows in column A of spreadsheet 1 have been processed.
For example my supplier has sent me a spreadsheet of 30000 rows of products, but we only sell 4000 of them. To date we have a had to do a ctrl F to find a part number then manually adjust the price in the master spreadsheet. It takes ages. I have 3-6 other spreadsheets from other suppliers that need this process too.
A script to do this would save me days of time.
Anyones help would be very appreciated, thank you.
 Posted by on
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Rate this:
(3/5 from 1 vote)
The easiest solution would be to create a VLOOKUP function in spreadsheet 1 based on part number for which the price would then be returned from the same part number in spreadsheet 2.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for Price updating:

Solutions: Stock Tracker