find blank cells in column and average the cells below

Hello,

I have a worksheet that has some data that is a copy and paste from 2 different sheets. We calculate the percentage complete and then manually calculate the differences. I need some help in creating a macro to automate this process. Can someone please help.
Attached is a sample worksheet with "Sample" as the worksheet with the data and "Result" is what I am trying to achieve.

I want to be able to find the first blank cell in column E and then calculate the average of all the digits before the next blank cell is found and so on.
The rows between the blanks will vary based on the month and the week the report is run but will always have a blank cell before the data for the next person. The format will remain the same though.

Then, as per the results worksheet.
1. Insert 3 columns for Target % (E), Distribution % (F) and the Difference in % (G).
2. Calculate the average percentage for Distribution in Column (H).
3. Values in Column F are essentially copy of calculated values from column (H).
4. Column E is the % complete using the formula for Column (D) and (E).
5. And finally column G is the difference between column (E) and (F).

I part I am struggling the most is the calculations in column (H).

I really appreciate your help.

I have also asked this questions here

You have to copy and paste formula every time.The array formula after entering the formula you should press ctrl+Shift+ Enter key not simply enter key.You can drag formula till the last row.

In the attached file Macro "Paste_Formula" will paste all formulas for all rows. You need not do it manually.

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).