Hi
I'm running windows 7 and Office 2010
I have a price list in excel format which consists of four columns. Part#, Description, Buy Price and Sell Price. This then gets converted to CSV and loaded into a database
What i now want to do is the following....
When my supplier sends me an updated price list i need the new excel file to compare with the excel old file and only override changes in price in the old file ready for converting to CSV and uploading again. Leaving anything that hasn't changed as it is
Is this possible?
I might also want to add two more columns to the original old file in the beginning for searching within the database. This would mean that the 'old file' would now have 6 columns and the 'new' file would always have four. They would be in the same place so would this still work?
Any assistance greatly appreciated
I'm running windows 7 and Office 2010
I have a price list in excel format which consists of four columns. Part#, Description, Buy Price and Sell Price. This then gets converted to CSV and loaded into a database
What i now want to do is the following....
When my supplier sends me an updated price list i need the new excel file to compare with the excel old file and only override changes in price in the old file ready for converting to CSV and uploading again. Leaving anything that hasn't changed as it is
Is this possible?
I might also want to add two more columns to the original old file in the beginning for searching within the database. This would mean that the 'old file' would now have 6 columns and the 'new' file would always have four. They would be in the same place so would this still work?
Any assistance greatly appreciated