Counting items in other worksheets and placing those results in a single worksheet

[rkapadia16]

Hi,

I am new to Excel VBA and I am currently experiencing some difficulties in producing a VBA code that will do the following:

I have about on average 50-60 worksheets in each workbook and what I want to do is create a new worksheet and count the number of dates in the other worksheets in the workbook and place that value into the new worksheet.

So for example:

In a particular worksheet, in cells A10:A16, I've got the following dates:
20/10/2007
21/10/2007
23/10/2007
25/10/2007
29/10/2007
31/10/2007
01/11/2007

There are 7 dates in this particular worksheet and I want this number to be displayed in the new worksheet that was created in the beginning. This value can be displayed in cell A2 in the new worksheet.

Then I want the macro to move onto the next worksheet and count the number of dates and place that value in the cell below (cell A3) the previous value that was inserted. All dates will start from cell A10 in each worksheet - so it will always be in a standard form.

Is it possible to do that?

I'd be grateful if someone could help me on this.

Thanks!

[JBeaucaire]

Give this a try:

Please Login or Register  to view this content.

[rkapadia16]

Thank you very much! That works perfectly!

[JBeaucaire]

Great.

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED].