Can't map headers together

[forrestgump1980]

Hi there,

Pretty vague question but I have been set the task of amending someone else's excel VBA and I am trying to work it out. Basically I think the change I need to make is in the code below (There is a lot of extra code not included). The code below matches up the headers if the headers have the same titles, however I need to amend the code so that the code is mapped e.g. Surname = last name, address 1 =Street_Address etc. I thought about mapping the headers on an excel sheet and then referring to that using either something to do with vlookup or index etc. Any advice would be useful.

Please Login or Register  to view this content.

Regards,

Forrestgump1980

[dflak]

It does not look like we have the whole picture HDRFILE1ROW and HDRFILE2ROW look like they are arrays that are defined somewhere else in the code.

Instead of patching this code, we might be able to build something "from scratch" just as easily if we had a sample workbook. I think all you would need to do is provide the headers. I don't think any actual data would have to be provided.

[forrestgump1980]

Thanks for your reply the headers are as follows:- id=id, effectivedate=effectivedate, FirstName=FirstName, Surname=Surname, address1=Street, address2=Area, address3=City, address4=Postcode. I am currently trying to create some loops to see if I can get the code to work. Any help you can provide I am very greatful.

Regards,

Forrestgump