Count the number of filled rows in sheet 1 and display in sheet 2. Please help

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

Thanks for your reply.
Say example,
1. In my sheet 1, if i have 10 rows of both red colour cells and green colour cells, then i would like to get number 10 in sheet2(A1) and
2. in my sheet 1, if i have 5 red colour cells then i should able to get number 5 in next coloum in sheet 2 (B1)

Thanks

Your sample is colored by conditional formatting and there's no condition set for green?

IF the result is OK then it will be green,
If the result is REQUIRE ATTENTION then it will be red

Does this help?

Please Login or Register  to view this content.

brilliant
thanks a lot

You're welcome. Glad to help out and thanks for the feedback. Please mark your thread as Solved: Either Click Thread Tools above your first post, select "Mark your thread as Solved" Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.