vba find and replace date by date

[kelvin_9]

Hi All,

i need a vba to do the following, can someone please help?

"136 list" contains 14days of my employee roaster, i need to loop through these 14days, find a match on column E with blue cell and column G with "abc"
then, replace first 7 names in "136 week1" and last 7 names in "136 week2" date by date

alternative, how about CF in vba?

thank you very much for your guidance

 

[kelvin_9]

anyone please can help?

thank you very much