sounds like you just need a countif

in sheet 2, cell B2..

=COUNTIF(Sheet1!A:A,A2)

Will give total # of times this phone number is on the other sheet.

Paste the formula to bottom.

"Paul" wrote:

Hi can anyone help me??
I have two worksheet (1 & 2) with telephone numbers in column 'A'. What I
need to do is run a macro in sheet 2, that will identify the same numbers in
sheet 1 and total them up for me. Is this possible or is there a better way
of doing this?
--
Paul