Count the number of active rows in sheet 1 and display

[krishnaa_kumarr88]

HI,

Thanks for looking at my query. Its really urgent and please help me.
I created a interactive userform. When you open the excel , it will automatically open the userform in which you can input the data which will store in the spreadsheet. I done with that and its working good.
My trouble is, i would like to count the number of filled rows in sheet 1 and display the total number of filled rows in sheet 2. Please check my attachment . In attachment please check sheet 2 for more information.
Please help me guys.

Thanks

[Rudi]

Hi Krishnaa,

First, you do not have a sheet 2 in your sample file and there are no instructions.
However, to get a count of filled in records from sheet 1 on sheet 2, you can simply use a COUNTA() function.

Have a look at sheet 2 in the attached file...

TPM Excel checkbox1 (1).xlsm

[krishnaa_kumarr88]

thanks a lot rudi