>>>> QUOTING Adam Alsop to Dik Coates <<<<
DC>In cell G5, for example, I want to be able to add two values B5+D5
DC>and in cell K5 I want divide G5/H5. This is easy enough, but, I
DC>want to be able to do this for G6, G7... G30, etc.
DC>Is there an easy way copy the formula and have it have it do
DC>calculations relative to a position?
AA> Hey there! :)
Howdy, Adam...
AA> You can use the Format Painter - select the cell that has the initial
AA> formula, and then hit the Format Painter button and highlight the
AA> portion of the column that you want to change.
Thanks... will give it a try... didn't know anything about the 'Format
Painter'
Regards Dik
... Python of Borg - And now for something completely futile.
___ Blue Wave/QWK v2.12
--- Maximus 3.01
---------------
* Origin: StarLab! In Orbit, Lindsay, Ont. (705) 328-2954 (1:253/232)
|