Dear Mr.Robert,
I have checked and found formula : =IF(VALUE(YEAR(NOW()))=VALUE($A$7),IF(AG99="","",AG99),"") is working, I need some more help on this,

1. Can you please explain VALUE($A$7) , this part of this formula. In particular meaning of $A$7 here,
2. Can you please give me the formula for Cell CellB9 data will copy from cell AE18 for this year.
These will make me clear to wire formula for other cells,

Will appreciate your help on this.

Thank you,

Best 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