Hi Everyone

I've scoured Google for an answer but because I don't know specifically how to word it I get lots of pages on using data validation instead of what I want

What I'm looking for is a macro/command that will compare a list of column headers in one workbook which contains the same column headers as the 4 other workbooks to see if the column headers are in the same order and provide a summary report showing that they match

so if workbook 1 has columns apple, banana, carrot, pear

the report workbook would have have the same list and would show as yes, yes, yes, yes for the ones that match

however if workbook 1 has columns apple, banana, pear, carrot

the report workbook would have yes, yes, no, no as they are not in the same order anymore

Ideally it would just show a final text box summary saying "All columns Match" or "Error - some columns do not match"

Sounds complicated to someone like me and I've tried to figure out/learn the STRCOMP to see if it works but my skills are way below par. Happy to learn myself if anyone has a decent link to something similar

Thanks for any and all help

Dan_B