S
Shon
Can I automate filling down a formula e.g.
if I have to formulas a1+b1 and answer is in c1 I then want the next formula
to calculate a2+b2 and put answer in c2 and repeat this down 20 rows. I
currently have to put the formula in manually as the cells references
containing the data may change sometimes
Any ideas?
if I have to formulas a1+b1 and answer is in c1 I then want the next formula
to calculate a2+b2 and put answer in c2 and repeat this down 20 rows. I
currently have to put the formula in manually as the cells references
containing the data may change sometimes
Any ideas?