Hey thank you for simplifying my code, I am a little confused, as i still have a couple of issues.

1.) when values are added to those generated columns despite the totals row carying the formulas the totals arent updated. You have to click in the totals box, click on the formula and hit enter for it to update.
2.) Even after forcing the totals row to update I dont see where it copys that data over to A2-D2 on that applications corrosponding spreadsheet.

Did opening this in 2007 change things, or were you not able to look at that?

Thank you so so much, you are the best.