Update rejoin dates in master sheet

[gssachin]

Hi,
I need a macro to update values from input sheet to master sheet.
Input sheet having three columns emp no, vacation date and rejoin date.

Macro has to find emp no from master sheet and then find vacation date as per once it found macro should update rejoin date next to vacation date column and it should do upto last row in input sheet

 

[gssachin]

Can anybody help.....

 

[My Aswer Is This]

We need specific details.

Are the two sheets named:
"Input" and "Master"

You said:

Input sheet having three columns emp no, vacation date and rejoin date.​

What columns are these?

Are these columns "A" "B" and "C" ??

You said:

Macro has to find emp no​

Where is emp number?

What column ?

See we need details like this.

 

[gssachin]

Hi,

Sorry for Inconvenience

Input Sheet
Emp No Vacation Date Rejoin Date
A B C
9523 18-11-2011 17-12-2011
9524 05-01-2018 05-02-2018

Master Sheet (Before Macro)
Emp No Vac 1 Rejoin 1 Vac 2 Rejoin 2
A B C D E
9522 01-01-16 03-03-16
9523 05-05-11 06-06-11 18-11-2011
9524 05-01-18

Required Result
Master Sheet (After Macro)
Emp No Vac 1 Rejoin 1 Vac 2 Rejoin 2
A B C D E
9522 01-01-16 03-03-16
9523 05-05-11 06-06-11 18-11-2011 17-12-11
9524 05-01-18 05-02-18

 

[gssachin]

Can anybody Help on this....