I have a spreadsheet that tracks movement of machines in different locations.
I have two sheets. one sheet gets changed weekly to show the weekly totals
for each loacation (16 locations all together) and the other is a yearly
production for each loaction. what i want to do is have the yearly sheet
update the quanitity each time the weekly sheet is updated. for example if
the weekly sheet reads 5 for memphis and 3 for los angeles for week 1, the
yearly will show 5 for memphis and 3 for los angeles. but when week 2 rolls
around i change the values of the weekly sheet where memphis is now 7 for the
week and 16 for los angeles. now the yearly sheet will show 12 for memphis
and 19 for los angeles. is this possible? if so what would hte macro look
like?