Hello all, i need help on 1 issue.

I have a column that has subtotal(109,a1:a1) to check if visible.

Then i need to create a macro that if subtotal = 1 (row visible) then puts in another column value today. But the data base is constantly increasing which means that the macro needs to do probably a while till subtotal different then empty.

How can i do this?

Please let me Know if u need more info