filter data and than load it into master file

coolin

New Member
Joined
Aug 17, 2009
Messages
2
Hello people,

I have a master xls file that needs to be updated monthly with data from source file.

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

Note that the source file must be open before the macro will start, in case it's close a msg box should appear with a message to open the source file.

If anyone have done something similar I will appreciate the help.

Thanks!
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,130,311
Messages
5,641,453
Members
417,210
Latest member
rins

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top