I have some issue with the macro, after creating macro when i use the shortcut (ctrl+Y, as per ur suggestion) the cell in which the cursor is it update with yes but the D cell of particular row won't get update to the date, instead of that the cursor goes to the cell (in which the today() formula was used n then converted into value while writing macro). so, ultimately while pressing ctrl+y the only B column get update to yes & not the date in d column.

Hi,
I read through my explanation and realized that one small thing was not to 100% clear: After typing =today() in the cell you should hit enter! After this continue with copy... etc.

After you have recorded this macro again, using the clarification above, try it again. If it still doesn't work, publish your recorded macro here and I will hopefully find the error.

You can find the macro details via the menu Tools / Macro / Macro... (or Alt-F8). After this select your macro and click on "Edit". Now you will see the macro and can copy-paste into a reply here.

Kind regards
Bjorn