Sorry I missed all the fun, but it sounds like you are cruising now!
--
Y


"Gatsby" wrote:

G H
450.00 450.00 (G9)
425.00 875.00 (G10+H9)
430.00 1320.00 (G11+H10)
422.00 1742.00 (G12+H11)
1742.00
1742.00
I have to type in the formula in H each time I make an entry in G in order
to get H to complete. If I drag the auto complete down it fills in the last
entry all down the column, which I don't want to happen. Why doesn't excel
recognise what I'm at and just fill in column H for me? Although the above
example only shows four entries, it's the same after seven. The Autocomplete
box is ticked.
Help anyone? - Gatsby