VBA to copy data from cell above if blank and stop when next data, then repeat

[LokimotiveUK]

Hi All!

I've been going through tutorials for the past two days to start my journey in VBA, and need some help for an immediate problem. I currently receive a report from an ACCESS database that I don't have access to, and need to get the data filled correctly so that I can then start using vlookups etc and (hopefully) create some automated timesheet population and calculations. The format of the report does not change, but the amount of data in it will alter based on the amount of users clocking in and out every day. I've attached an image showing the needs that I have; I've tried to do some VBA myself but I'm just to new at it to get anywhere, except for confused.

Can anyone help me?

 

[LokimotiveUK]

Sorry, seems image did not imbed. Link to it here: https://www.dropbox.com/s/vg08uxb9kma2tza/VBA Help.jpg?dl=0

 

[LokimotiveUK]

I managed to solve this by recording a macro and then applying it across multiple sheets with a button. Macro function recorded is as follows:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">Select columns E:H
F5
Special
Select blank
= and then up one cell using the arrow key
ctrl + enter</code>As you can maybe tell by my workaround, I'm still new to VBA, but am keen to learn. Hope this helps someone with a similar problem