Matching more that one header

[akq125]

Hello,

I am processing several raw data files that have different column headings for the same data. For example current rates can be name three different ways. I've been using worsheet function match to match columns with wildcards but it seems to only work if I have two different match types. Is there a way to search the headers with multiple criteria until a match is found and then copy the column data as I have already working in my code? I may also want to add more match criteria as data files change over time. If no match is found there is no need to copy. Thanks for your suggestions!

Please Login or Register  to view this content.

[nilem]

maybe so

Please Login or Register  to view this content.

[akq125]

I repeated your code for each column header - worked great!!