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
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Watch MrExcel Video

Forum statistics

Threads
1,108,501
Messages
5,523,293
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top