update master file with filtered data

Hello people,

I have a master xls file that needs to be updated monthly with data from raw data file.
I want to create a button on the master file with a macro attached that will check the headers from the raw data (the file it's open) to have the same value and order like the headers in the master file, in case of differences a msg box must will say that are differances between the 2 files, and the macro will stop. I have to do this checking part because the header of the raw data file can be changed (order of the columns or titles.)
In case there are no differences between the 2 files, I want the raw data file to do a filter on "Deal Description" column for values that contain "MDP", copy and paste data in the master file on the next available blank row, than do another filter on "Pre-Sales ID" column for values that contain "DDP", copy and paste data in the master file on the next available blank row.

I have attached the structure of the master file were I have to add the button that will do the check and all filtering and copy and pasting.
If anyone have done something similar I will appreciate the help.

Thanks!

Originally Posted by arlu1201

Will the raw data file be open at the time of running the macro or should the macro open it?

raw data file should be open before you run the macro, in case it's closed should see a msg box saying that you must to open the source file