First, thank you, thank you, thank you. I've learned a tremendous amount on this board (almost entirely non-VBA though!). And now it's time to start learning VBA; unfortunately, those "important projects" always seem to be given to us before we can start learning about the basics So, I'd be incredibly grateful for any help or pointers on how to get this to work.

Summary: Ultimately, I'm looking to match the "headers" - the top cell in any given column - of a non-active Excel file, and copy that column to a similarly labeled column in the "active" worksheet.

In detail: The active master excel worksheet that I'm using (target) & its tab names never change. That master sheet's name is "Applicant file.xlsm"; There are multiple tabs in this workbook, but the target tab will always be titled "Applicant List". In this tab, I also have 6 columns, with column headers (the top-most cell in the column): name, address, SS, Ph #, email, other. I'm interested in matching, say, 5 of them.

I also have a non-active (source) excel file. In the non-active excel file, the order of the columns could be completely different than the master sheet's "Applicant List" tab, and could contain more than 10 columns (some of which of course won't be found the "Applicant List" tab).

Ultimately, I'd like the user to be able to click on the button with the assigned macro, have that macro prompt the user to select the non-active excel file (dialog box); then, have the VBA script match the "Applicant List" headers to source file headers, and copy the columns below every header that has matched from the source file to the "Applicant List" tab.

It is worth noting that some of the columns may contain blank lines/spaces.

I'd appreciate, really, any help on this!!

Thank you!!!!!