Forum Discussion
Help updating and comparing priclist
Hello, I was hoping someone here could help me out. I have looked on the web, but do not seem to know what I should exactly be looking for. So here goes: I have a pricelist with part numbers t...
Dmanic This is actually very far from "relatively easy". This will most likely require VBA code.
Conceptually, the code would
- open the original file (which, btw, is a CSV file, not a spreadsheet, are you aware of that?)
- open the update file
- loop through all rows in the update file and for each row
- find the Part number in the original file (in which column? There are two for part number in the original)
- if the part number is found, write the NET.PRICE into the (which ??) price column
- if the part number is not found, add the data from that row at the bottom of the original list.
- close the update file
- save and close the original file.
Writing that kind of code is totally possible, but it needs a bit of experience.