Dear Mr.Robert,
Many thanks for your kind assistance.
I am working as per your advice and will let you know whether this is working or not,

Thanking you once again for your helping hands,

Regards,
Shahadat
=========================================================================== =================================




Quote Originally Posted by Trebor76 View Post
Hi Shahadat65,

Welcome to VBA Express!!

You don't need a macro, just an IF statement to check what the current year is and only return the desired values if it this year. For example the formula in cell B7 would look like this:

=IF(VALUE(YEAR(NOW()))=VALUE($A$7),IF(AG99="","",AG99),"")

Regards,

Robert