S
suzanna
i am trying to create a reference to a particular cell
that will always stay with that cell even if i insert a
column. for example: if i want A1 to be the same as the
number in b1. i would type =B1 in the A1 cell. the
problem is when i add a new column B. because now A1 is
referencing the info in C1 and i don't want that! if any
of you can figure out what i'm asking, please help!
that will always stay with that cell even if i insert a
column. for example: if i want A1 to be the same as the
number in b1. i would type =B1 in the A1 cell. the
problem is when i add a new column B. because now A1 is
referencing the info in C1 and i don't want that! if any
of you can figure out what i'm asking, please help!