Fix the reference cell

[Help!!!!!!!!!!]

Hi,

IF A2 is the referce cell for the if formula & reuslt cell is A1,

If i cut A2 Row & palce it in A3 the refrence cell should be to the same
place.

Please help me in solving the same.

Thanks & Regards,
Manjunath

 

[Pete_UK]

Try just copying A2 to A3 (or row 2 to row 3) and then deleting the
contents of A2 (or row 2).

Hope this helps.

Pete

 

[Shane Devenshire]

Hi,

That depends on what you mean by reference cell should still be the same.
If you cut and paste a cell all references to it follow it. If you copy and
paste a reference cell none of the formulas that refer to it are transfered
to the new cell, they will all reference the original cell.

And whether you are doing this for a cell or a row makes no difference.

 

[Max]

One other ponder, maybe something like this:
In A1: =IF(INDIRECT("A2")="","",INDIRECT("A2"))
A1 will always point to what's in A2,
regardless of what you do "physically" with A2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik