How can I count the no. of entries in a column.

[Barnali]

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.

 

[Bob Phillips]

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)

 

[starguy]

you can do this by using COUNTA function.
suppose you have data in col A of Updated Overflow sheet, put in your
specified cell in WTS sheet the following function.
=COUNTA(A1:A100)

you can extend this range

hope this would help you.