Been awhile since I last visited. I would appreciate a helping hand. I have the following situation:
I keep a spreadsheet (mainsheet) that lists all the pertinent Data for my inventory. It is sorted by make, Model, and year of the car. Each car has a stock number that is unique.
Every day the accounting department updates a proprietary accounting system and therefore my costs change daily. The accounting system has a function that I can manually export to an excel spreadsheet some very basic data. What I want to do is to write a macro in my spreadsheet that compares the stock# data in the "mainsheet" to the stock# data in the manual sheet and, if it is a match cut and paste the cost data to the mainsheet.
I keep a spreadsheet (mainsheet) that lists all the pertinent Data for my inventory. It is sorted by make, Model, and year of the car. Each car has a stock number that is unique.
Every day the accounting department updates a proprietary accounting system and therefore my costs change daily. The accounting system has a function that I can manually export to an excel spreadsheet some very basic data. What I want to do is to write a macro in my spreadsheet that compares the stock# data in the "mainsheet" to the stock# data in the manual sheet and, if it is a match cut and paste the cost data to the mainsheet.