I need to find an expert with Excel. I have multiple XLS files and one CSV file. We have about 1800 parts on in our master CSV file and each part may be compatible with only one product or could be compatible with many products. The 10 spreadsheets have more than 10,000 items listed but many are the same on other spreadsheets. I will send you all spreadsheets and I need you to populate fields stating that part X is compatible with product A, B, C etc..
We will need to know exactly what parts on the csv file cannot be found on any spreadsheet and also what parts on the spreadsheets cannot be found on the CSV file. The final master spreadsheet with all listed on on ss will also need to have each product that that part works with.
Please only bid if you are very experienced with sorting, formating and using Excel.