I have to combine several worksheets originally based on standard columns into a single worksheet, but users have randomly included extra columns. So for example if the original headers were:
|Date|Forename|Surname|Address1|Address2|Town|Car user|
Some now have additional columns inserted such as:
|Date|Forename|Surname|Married?|Address1|Address2|Town|Date of Birth|Car user|
Or:
|Date|Forename|Middlename|Surname|Address1|Address2|Town|Car user|Parent?|
How do I capture all the data aligned under the original column headings (so Address1 data will all be in the same column etc), while including the new columns? It doesn't matter where the columns are, providing they are all present.
Many thanks.
HughT
|Date|Forename|Surname|Address1|Address2|Town|Car user|
Some now have additional columns inserted such as:
|Date|Forename|Surname|Married?|Address1|Address2|Town|Date of Birth|Car user|
Or:
|Date|Forename|Middlename|Surname|Address1|Address2|Town|Car user|Parent?|
How do I capture all the data aligned under the original column headings (so Address1 data will all be in the same column etc), while including the new columns? It doesn't matter where the columns are, providing they are all present.
Many thanks.
HughT
