I have taken on a job for a not for profit training organisation. They have several years of excel based archival records of qualifications. I am looking to firstly combine or relate them so they are efficiently search-able. Presently the are in different versions of Excel, have few common layouts in component worksheets although Family Name , First Name, Certificate , qualification and date issued are common.
I have used Excel extensively in Financial and accounting applications and eventually (if I can resolve the combination and field issues) migrate the data to an Access database.
In total there are several hundred individual worksheets.
So I am old grey and bound to ask really dumb questions please bear with me. hopefully I have either found solutions or resolved problems inthe murky past and may be able to contribute.