Hi again,
This is working almost perfectly now! I have to thank you for coding these functions, and also for your patience with me!
I have had a thought about the formula in the total column not working. Is it possible to do something along the lines of:
If row fill colour = rgb(246, 247, 248), calculate the sum of cells below. The range end is when the code gets to another cell with the fill colour of rgb(246, 247, 248). If this is possible and you put this code after the one you came up with previously and use an If Else statement so it doesn't run on blank rows, I think that'd be it.
Everything else is spot on and is working well. It's just that Sheet2 needs to be able to work on its own.
EDIT:
Ah ha! Here's what I was looking for:
Bookmarks