Macro code to do Vlookup from two work sheets-reg

[skml]

Dear Team

I have attached excel workbook named Test having three worksheets FINAL, LEAVE AND ABSENT

I want data from Column B of Leave Worksheet and Absent Worksheet to be populated in Column B of Final Worksheet

Kindly give me a macro code.

Sample data is attached for your reference

Thanks and Regards

[Mumps1]

This macro assumes sheet FINAL starts out with only the headers and no data.

Please Login or Register  to view this content.

[skml]

Thanks for your feedback Working fine

Can this be done using Vlookup through macro

Anyone can help me on this

[Mumps1]

Just curious. If the macro is working for you, why would you want another macro using Vlookup?

[Sintek]

Here is formula solution...

Please Login or Register  to view this content.