Looping Formula Help

hi

I need a bit of help - I have a basic code which still needs a bit of work. But the main bit I need a bit of help with is the formula. I need a sum in the Gross pay Column for each row that there is and same for Net pay.

From the Output test.xlsx file attached:

The Gross pay is all the yellow columns added together.

The Net Pay column is the Gross pay from above less all the light blue columns plus the 2 green columns.

Here is the main code:

Please Login or Register  to view this content.

hi leane2011, option for formula issue basing on the posted file:

Please Login or Register  to view this content.