Need VBA code to compare two sheets

Hi Experts,

I am a newbie to excel, need to compare sheet1 and sheet2 for multiple columns and place the result in sheet4.

* All the column name in sheet1 are not identical to sheet2.
* column names in sheet1 and sheet2 are related using the mapping given in sheet3.

The below is the example scenario

Sheet1
NAME DOJ PROFILE_CREATE_DATE Location id LAN
David 2013-12-31 2014-02-01 09:34:00 UK 125016 dmill2
Yu 2014-01-01 2014-02-17 09:34:00 CHINA 184217 yxin2
Smith 2014-01-02 2014-01-25 09:34:00 India 42876 spatel1
Sam 2014-01-03 2014-01-21 09:34:00 USA 16742 sander1

Sheet2
e_id location LAN NAME PROFILE_DATE
125016 UK dmill2 David 2014-02-01 09:34:00
184217 CHINA yxin2 Yu 2014-02-17 09:34:00
42876 India spatel1 Smith 2014-01-25 09:34:00
16742 USA sander1 Sam 2014-01-21 09:34:00

Sheet3
Sheet1 Sheet2
NAME NAME
LOCATION LOCATION
DOJ NULL
PROFILE_CREATE_DATE PROFILE_DATE
ID E_ID
LAN LAN


Now i need the output in sheet4 as below

NAME DOJ PROFILE_CREATE_DATE Location id LAN
TRUE N/A TRUE TRUE TRUE TRUE
TRUE N/A TRUE TRUE TRUE TRUE
TRUE N/A TRUE TRUE TRUE TRUE
TRUE N/A TRUE TRUE TRUE TRUE

For this firstly,i need to replace all the column names in sheet2 as per mapping in sheet3.
For ex: column name e_id in sheet2 should be renamed to ID

Secondly match sheet1 and sheet2, then write the result in sheet4.

Moreover, this should be the routine task for me and every time number of columns changes. Sometimes number of columns would be 500.

Could you please help/guide me to fix this?

Thanks,
Gokul

See the attachment

compareSheets.xlsm

Excellent. Many Thanks for the code.

I can see one discrepancy in this.

In sheet4(output sheet), For column-name(PROFILE_CREATE_DATE) data is wrongly mapped to column Location in sheet1 and sheet2.

This is due to order of column name in Sheet3 and sheet1 are different.

is it possible to modify the code to handle even the column name in sheet3 are of different order.

Again Thank you for the help.

Sory.
Just repalce

Please Login or Register  to view this content.

by

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

replace by

Please Login or Register  to view this content.