VBA Code to Insert VLOOKUP Formula in a Cell and Compute for Average

Greetings!

I have a scenario with my workbook, I am trying to insert a formula that will compute an average of specific number of cells based on the given values from the userform.

First in the worksheet "Performance", I will open a userform by clicking the button "Find Rate" and will input data,
The first field is the Agent no., which will become the reference for the vlookup (example is Agent2)
Next field is I will input the starting date where the computation of the average will start, (example is 4th day)
Then the last field is where I will input the number of days that will compute the average (example is 7days) starting from the second field (4th day)

Scenario 1.jpg

Second scenario is given with the Agent no. (Agent2), the cell D4 will be inserted by the formula to vlookup "Agent 2" in the other worksheet named (DAILY), and will find the 4th day and will start to get the specific cells (under column "SHFTMO", since I am looking for the average of Shift Monitoring -cell D4 sheet "Performance") 7 days from 4th day. then will compute for the average based on the given number of days to compute.

Scenario 2.jpg

here is the sample file.

Agent Performance Scenario.xlsm

hope someone could help me on this. I really appreciate your feedback regarding this.

Thank you.

How about rearange your data on a summary sheet?

In that case you be able to use pivot table for analyzing the data.