You don't need a macro, jus

=COUNTA('Updated Overflow'!A:A)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Barnali" wrote in message
oups.com...
Hi
I have to count the no. of entries in a particular column in a sheet
named "Updated Overflow".Whenever new entries are added the total no.
should appear in a particular cell in another sheet named "WTS".Could u
please help me to write a macro for this.

Thanks in advance.