Macro to insert rows based on Date and Time Cell

[Foxvh]

Hi,

i have a report which inputs rows of data into a (To Be Allocated) sheet and would like to have these sorted by Date and Time Allocated using a macro that places them below a merged row with the date as the header based on Date Cell (A:A) and then sorts the rows underneath the date header by time (E:E).

columns
Date (A:A)
Time (E:E)

any help or guidance would be much appreciated.

Thanks

 

[Foxvh]

Thanks that works great for inserting the date rows.
Sorry i meant a macro that will cut and insert the rows with data from To Be Allocated to the Schedule sheet, using the A:A column as the criteria of if it gets inserted and where it gets inserted.

so if A:A in To Be Allocated is blank skip, if A:A > 0 (8-JUL) then insert row to Schedule under the merged row (8-JUL) in Schedule.

 

[DanteAmor]

Thanks that works great for inserting the date rows.
Sorry i meant a macro that will cut and insert the rows with data from To Be Allocated to the Schedule sheet, using the A:A column as the criteria of if it gets inserted and where it gets inserted.

so if A:A in To Be Allocated is blank skip, if A:A > 0 (8-JUL) then insert row to Schedule under the merged row (8-JUL) in Schedule.

Sorry, I don't understand what you need.

This is your image with the result that you want, the image is blank, I do not see that you want data in the result image.