ExcelBanter - Cell References

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell References (https://www.excelbanter.com/excel-discussion-misc-queries/176562-cell-references.html)

I have a formula with a long string of cell references - ("AVERAGE" this long
string of cell references"). I want to copy the cell references one column
space to the right and instruct it to use the same set of references, only
one column space to the right of each original cell reference. For example,
series B3,G3,L3, etc. would become series C3, H3, M3, etc. The OFFSET
function in help is similiar but not the same as what I want to do here.

hi
change your cell references from reletive to absolute ie
from A1 to $A$1.
this way they will keep the origional reference.

Regards
FSt1

"DOUG ECKERT" wrote:

I have a formula with a long string of cell references - ("AVERAGE" this long
string of cell references"). I want to copy the cell references one column
space to the right and instruct it to use the same set of references, only
one column space to the right of each original cell reference. For example,
series B3,G3,L3, etc. would become series C3, H3, M3, etc. The OFFSET
function in help is similiar but not the same as what I want to do here.