G
Gidders
For a manpower planning tool, I want to be able to use a value in say cell A1
to be able to reference along from the current cell the number of columns
specified in that cell, and down a known number.
For example if A1=4 then I want B2 to point to (say) (C+A1)3 ie G3, & B3 to
point to (D+A1)3 ie H3 etc so that I can change which column B2 point to by
changing the value in A1
to be able to reference along from the current cell the number of columns
specified in that cell, and down a known number.
For example if A1=4 then I want B2 to point to (say) (C+A1)3 ie G3, & B3 to
point to (D+A1)3 ie H3 etc so that I can change which column B2 point to by
changing the value in A1