For each loop only displaying last loop in all of my ranges

Hi everyone,
I'm hoping someone can help me - I'm really new to VBA and trying to calculate an incentive pay out for each person as long as they have certain attendance and a certain score.
But when I run my code it only shows the last persons incentive over all of the selected cells.
I'm sure it's a simple fix but I just cannot work it out.
Would really appreciate the help here is the code.

Edited - I have attached an example spread sheet for you to look at with that the figures should output.

Please Login or Register  to view this content.

Thank you very much in advance.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

you have 3 nested loops, so in total you run set of commands between

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

11*11*11 = 1331 times, but output always go to (one of) 11 cells in range I8:I18

in other words, for each of these 11 cells, you calculate 121 values , but overwrite previously calculated with new one, so at the end of the day your code is equivalent to 2 outmost loops on their last elements and thenm looping through I8:I18, like:

Please Login or Register  to view this content.

Hope this will help, but if it's not enough, would you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

Hi, thank you so much for looking in to my code.
When I remove the loops it just outputs 0.
I want the loops to go through all the attendance list and their scorecard list on sheet 2 to calculate the incentive and output by the correct name on sheet1.

Please excuse my spread sheet it's only there as an example as it's not the real one so doesn't look organised at all.
I'll attach the spread sheet and hardcode how the output should be so you can see.

Thank you very much,