I have an excel spreadsheet that I download from a third party server that contains a single sheet with makes, models, vins and prices of used vehicles sold in my company. I would like to create a script/macro that will take this information and filter it by the make (in column B on the USEDCARS sheet) column and copy those rows that contain that make to a separate sheet that the script will create and label it the name of the make of car. The makes of vehicles that the script needs to filter by are AUDI, BMW, MB, MINI and all other make appearing in that column are copied to a new sheet called OTHER. Then I would like this spreadsheet to compare its rows to another spreadsheet called "sorted used inv" and add any new rows no present in sorted used inv to the sorted used inv other page. Any help would be much appreciated.
Bookmarks