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
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