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.
Regards,Please Login or Register to view this content.
Forrestgump1980
Bookmarks