Maybe a PivotTable will allow you to do what you need to do:
http://www.contextures.com/xlPivot02.html
http://peltiertech.com/Excel/Pivots/pivottables.htm


Regards,
Ryan---

--
RyGuy


"TFMR" wrote:

Dear All,

I have a list of employees and their mobile No. which provided them by
company, We have to check daily basis the sms count. I need one summary for
all the sim nos.
I want that in all the sheets macro check the no. and enter in summary and
in front mention the count of sms and if its found new no. then automatically
enter in the summary report and mention sms count.

Sheet is something like that

Sim No. Count of SMS
5212455 15
5212456 16