Counting and Grouping macro help

[ScabbyDog]

Hi. Attached is a sample workbook.

In sheet 'Games' I want something to look at the dates in column B and also look at column L(column L titled Importance). So in the workbook attached for the date 19/11/12 it would return 1 game with importance '4'. Then for the date 20/11/12 it would return 13 games with various importance. I want the results displayed so that I can then click into the 13 games and it then sub-catergorises by the time in column E.

I want it to be used for a tool to see how many games are on a date of what importance and what time they start at.

Any help would be great.


Counting.xlsx

[mike7952]

can you show your expected output?

[ScabbyDog]

Counting.xlsx

Here is the updated sample file with the output I want. I have only produced the sample output for the first 2 dates but you will be able to see what I'm after.

[ScabbyDog]

Anyone able to help me out with the output I want in the sample file I've attached directly above?

[mike7952]

This is close but Im not sure how to handle 00:30

Please Login or Register  to view this content.

[ScabbyDog]

That does a great job Mike. Much appreciated. Any work around for the 00:30?

[ScabbyDog]

I'm flexible and can easily change the times. I could change it to 23:00 - 03:00 or something similar if that would help?

[mike7952]

Try changing the 01:00 in the aheaders aheaders at the top of the code to 00:00

[mike7952]

Im not sure because 00:30 is not >=23:00 and <=03:00. Im not great with working with times.

[ScabbyDog]

Does the trick

Excellent. I still need to edit it to exactly what I need but what you've created is such a massive help!

[mike7952]

If you didnt want the formulas to show you can do this. Also add application.screenupdating false/true will speed things up a little

Please Login or Register  to view this content.

[ScabbyDog]

Where exactly do I put that line of code Mike? The code so that the formulas don't show.

[mike7952]

Please Login or Register  to view this content.

[ScabbyDog]

That's what I thought. But when I do it, it returns everything as 0.

[ScabbyDog]

Nevermind. I'll just write a simple copy and paste special macro to overwrite the formulas!

[mike7952]

Try adding a single quote before and after the worksheet name Games in the formulas.

'Games'!