Hi guys,

need urgent help here. So I have a workbook with 24 worksheets that represents 24 hours of a day and I need to find the maximum amount of vehicles parked on premises simultaneously. I have done this by writing a code and looping through the data and the code places a Y in the interval that a truck is on premises, at the end of each day the data is summed up and the data set for another day begins. I need a code that can

(i) Copy the dates from column A and placing it one row below in column A on the results spreadsheet whilst omitting blank rows
(ii) Have the results spreadsheet find the maximum for each hour interval of everyday

I have provided a workbook to help things out. THANKSS!!!!!Template.xlsm