I did spend last night making the totals move down but after thinking about it this morning it is a lot of effort for little pay back when we can just move the totals to the top.

Combined profit sheet

• Removed any merged cells
• Updated the Prize level lookup to something a bit easier to read
• Added in an extra column (c) to find the correct child from the take order sheet (doing this in one column makes the worksheet much faster)
• Then added in an index and match to columns D, E and G so that the numbers are dynamic as the child name changes
• Lastly, I have moved the sums to the top of the work sheet and extended the range so they will not need moving down each time – you could put these over on the right if you preferred.

SS Hours sheet

• Removed any merged cells
• I have moved the sums to the top of the work sheet and extended the range so they will not need moving down each time – you could put these over on the right if you preferred.

I had to update the childrens names on the SS hours sheet in a different way as this is basically an input sheet, but i think it works as it should.

It does take 5 seconds or so to complete but we can look at that if it works okay

Not looked at deleting yet (phase 2)

Have a look through and test it thoroughly, its it your workbook, so if there is anything i have done that you dont like or cant work with i will not be offended.

The one thing i do have to insist on is NO merged cells - they are the worse thing ever in a worksheet and will only cause problems. if you must have words spreadover cells use 'Centre accross selection' instead

Attached Files

Master popcorn Template_Purfleet-UpdatedFormulas_Test.xlsm (120.2 KB, 9 views)