Hi Folks,
My problem is simple. I have a monthly time sheet. The times are entered in cells C8:F68.
When some one has a annual leave day or a bank holiday they enter A/L or B/H.

I have a summary sheet and have placed a cmd button on it to hopefully search the sheets that are months or the year.
I know how to search the sheets and increment through them and not the 'Summary' sheet.

What I need to establish is how to place in my code the actual search criteria and also limit the range to C8:F68
On top of this I need to total each occurance of A/L and B/H and display them in two cells.

I have tried to do a search of the forum but with no luck.
Like I say I have managed to understand how not to select the 'Summary' sheet when incrementing through the sheets but its just the search for the A/L and adding them up!

Cheers for any help.