Macro to put lookup formula on visible cells only

[emina002]

Hi there, is it possible to put a lookup formula or other formula in a visible cells only, I have to filter specific data only and put a lookup formula in a certain column, and since there are other hidden rows, I don't need these hidden rows to have a lookup formula. Is it possible on macro?thanks

[Fotis1991]

Do you want to do this only using macro? I think that we can do it using formula.

In any case it would be better to upload a small sample workbook.

[emina002]

Here is the sample workbook I just want to create a macro/automated in just on click that can put populate formula on Monthly report(Filter Column A). Annual data should not have formula.Kindly see on March column that I put a sample formula on it

[Fotis1991]

Not sure that i understand your goal and in any case as you need to work with macros, i am not able to help you.

But just a thought.... In front of your formula in column H, just put one more IF....

=IF($A2="Annual","",IF($E2<=WORKDAY(H$1,TRIM(RIGHT($C2,2))*1-1),"On time","Late"))

[emina002]

I just used the IF condition vba code to skip all the word not "Annual". Thanks anyway