A
ajwilki
hi - I have a number of worksheets containing customer information in
different formats which I want to merge into a single worksheet. For example
worksheet 1 contains the columns: company name, contact firstname, contact
surname, contact salutation; and worksheet 2 contains the columns: title,
first name, surname, company. So the data from w1 could be mapped onto w2,
it's just all in a different order, and with different field names. It's on
such a large scale that I really need to find an automated way of
matching/mapping the different data into a single file. Can anyone help?
different formats which I want to merge into a single worksheet. For example
worksheet 1 contains the columns: company name, contact firstname, contact
surname, contact salutation; and worksheet 2 contains the columns: title,
first name, surname, company. So the data from w1 could be mapped onto w2,
it's just all in a different order, and with different field names. It's on
such a large scale that I really need to find an automated way of
matching/mapping the different data into a single file. Can anyone help?