I have two spreadsheets which I would like to compare information on both sheets that match. Then the matching information and details is dumped into a separate spreadsheet. For instance: If Sarah Connor with cert number 15622048 is located on both sheet then Sarah Connor with the corresponding information provided is placed in a results spreadsheet as a match.
Also wondering if the same information is provided regularly can it be exported from excel and imported into Access. Then can a query be used to automate the process.
Thank you fro any assistance and suggestions