Code for Vlook up

[Veeru]

Hi,

I am looking for a code which compare 2 data sets through Vlookup.

Code will copy data of SF Data from calculation tab from B3 till end and paste it in Vlookup sheet from A2

Then copy data from Weekly data for Week 18 from Col. C1 and paste it in Vlookup sheet from C2

Then apply vlookup formula in Col. D and then filter al #N\A vaues and if possibe segregte them in another sheet "Leaves"

Lastly for which week data needs tobe picked up should decide from summary tab Cell E3.

Thanks for your time.