I have 5 spreadsheets that contain a large ammount of information. The longest contains 630K records and each record haas a unique idetifier. The other 4 spreadsheets contain additional information about the records in the first spreadsheet, they vary in legnth. These other 4 spreadsheets contain the unique identifier that ties them to the larger dataset, but not every record is present, some records do not require the additional information that is stored in these 4 spreadsheets.
I need this to be consolidated into 1 spreadsheet. Where each of the 630K records will be in one place with all of the information available.
35 freelancers are bidding on average $51 for this job
Dear bmiller4evr, I want to do this "Consolida Several Excel Spreadsheets Using Unique Identifier" project now, let's start immediately. I have read the job description. Please read my PM Regards, Oliver
Hi I trust you are using Excel 2007, but in any case I propose to use Access to combine the worksheets using left outer join and return the resulting Excel file to you.