5

#### 510 Financeguy

month, when an additional row and column of data are added to the dataset.

For example, the formula is: Factor = SUM(C2,D3,E4)/SUM(B2,C3,D4)

and the data is arranged as follows:

a b c d e

1 16 79 17 13 14

2 - 58 49 88 14

3 - - 77 76 14

4 - - - 93 67

5 - - - - 23

The following month, an additional row and column of data is added...

a b c d e f

1 16 79 17 13 14 17

2 - 58 49 88 14 10

3 - - 77 76 14 11

4 - - - 93 67 97

5 - - - - 23 83

6 - - - - - 41

at which time the formula needs to be updated as follows:

Factor = SUM(D3,E4,F5)/SUM(C3,D4,E5)

Any suggestions on how I might go about doing this, perhaps with a macro?