Summarising results on a separate worksheet

**yummypanda43** · 01-20-2015, 06:42 AM

Hi All,

I have a workbook that analyses how long a vehicle is parked on premises for and for each interval that the vehicle is on premises a Y is displayed as show below. Screen Shot 2015-01-20 at 6.27.55 pm.png

As you can probably see, at the end of each day the number of Y's is summed up for each one hour time interval. What I would like to do is have a macro run through each day for each respective time interval and display the maximum number of vehicles on premises for each time interval.

Also I would like to have a macro loop through column A of the spreadsheet and place the dates without the blanks in column A of the results spreadsheet.

Help is very much appreciated. Thank You !

**YasserKhalil** · 01-20-2015, 06:49 AM

Can you attach the workbook to make it easier for anyone who wants to offer help to work easily?

**yummypanda43** · 01-20-2015, 07:18 AM

Here is the template of my workbook, it doesn't have the other codes in it, i hope it dosent make much of a difference. I can't seem to upload my coded workbook. Thanks a lot people !!!