Excel 2007 : macro to count sheet records

[nlm]

Hi,

I have multiple sheets in a workbook. Sheet1 is Totalrecords sheet contains all the sales data from different retailers. Rest sheets are named as per retailer's name e.g. John, James.

First I import all sales data in Totalrecords sheet from where I paste retailers data in their respective sheet.

To verify that each retailer has the same amount of data pasted from Totalrecords sheet, I apply count function in each sheet manually. With the passage of time, our retailers base increase. Will there be any macro which can count and display the number of records in each retailer sheet. I want to display just the number of records in each retailer sheet.

I am attaching a dummy file for your convenience.

Any help would be higly appreciated.



Thanks.