SOLUTION 1:
Right-click on the Summary tab and select VIEW CODE, then paste in this sheet-level macro:
It will re-evaluate the current sheet.
=============
SOLUTION 2:
Another simpler non-macro way is to change the way the numbers are appearing on the summary. Change cell Summary!C3 to:
=MAX('USA & Canada'!A:A)
Then put this formula in A15 and copy down:
=IF(ROW()-14>$C$3,"",A14+1)
Delete that row 140 as unneeded. Now your summary will only show rows needed.
========
Both of these approaches seem equally usable.
========
FINAL NOTE:
I'm a huge fan of the key column technique you're using in column A on all the country sheets, but the MAX() formula keeps reevaluating the entire column unnecessarily.
On A5 in each of those sheets and copied down:
=IF(C5="Yes",A4+1,A4)
...will do the same thing and greatly reduce the number of calculations going on.
Bookmarks