Formula to find the header and sum hours

Question

I have a auto-generated report from our time entry system. The report gives the name of the employee in one column, and hours worked in a separate column. However, I need to find a formula that will allow me to locate the lines that belong to the header and total per employee. I need this to be automated so I create a dashboard from the data drop report.

Employee hours report

I have tried creating a macro but It will only work if I can determine how many rows will be reported before hand.

Answer 1

This method is somewhat manual, but it gets the job done pretty quickly. First select the range you want to fill in the blanks for, starting with the first cell with text you want filled down all the way to the last cell you want filled down to. In my example, it'll be A3:A15.

In the Home menu, open the Find & Select dropdown and choose Go To Special... and select Blanks.

With the new selected range, type =A3 (or the first cell with text you want to filldown) and instead of just Enter press Ctrl+Enter (Cmd+Enter for Macs).

That will then fill each blank with the cell above it.