Manaully putting data in a cell wouldn't change the need to use a formula or
use a macro. You could probably still use a formula, but the formula need to
be changed. You have not provided enough information for anybody to give you
a response.

"Tufail" wrote:

hello,
now i am using this formula =IF(H13="Sale",MAX($A$1:$A12)+1,"") but now i
want a macro, because from now in H13 some data we have to input manually.
thanks in advance