Compare row beetween two workbooks if values are same or not

Dipendra

New Member
Joined
Sep 19, 2014
Messages
1
Hi All,

I need your help regarding the creation of a macro. I have two work books one is standard (Master file) which is saved in my local with predefined formula in it, the another workbook (Raw file) I receive every week.

Now every time when I receive the Raw file workbook, the order of heading get changed. I want to create macro which search A1 value of Master file into Raw file and copy the whole data present in that column and paste it in A1 of Master file. This activity should be repeated with A2, A3….so on until it reach empty cell in master file.

Also, if during the search in Raw if it does not find the value it give msgbox mentioning the missing cell value. Thanks in advance.

Regards,
Dipendra
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,700
Messages
5,833,213
Members
430,197
Latest member
edeibold

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