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.