So we enter the name in Take order and this copies to Combined Profit - Scoutbucks & SS Hours scoutbook money? Where is the third sheet?
I dont think the live update will work in this case, so i have added a button that will ask for the first and last names then add in the row copy down formulas
This does cause a few issues
- You are using direct referenced cells for example ='SS Hours Scoutbook Money'!I7. This will make the data wrong when we paste in the new child. I would suggest you use index & match (or vlookup) or sumifs to bring back the data on the 2 other worksheets as that will then be dynamic
- the total at the bottom of the combined sheet will need to be factored into the code. As will the totals on the SS hours sheet.
Test this bit out and let me know what you think.
Bed now!
Messenger? is that facebook? No way!