View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
garbon2535 garbon2535 is offline
external usenet poster
 
Posts: 3
Default Move cell and maintain reference

I have a worksheet with a simple function. I want to be able to move the
function from one cell to another cell and maintain a reference to a cell in
a certain location relative to the new cell.

Example:

My function is in Cell A3. The Function has a reference in cell A1 which is
two rows above Cell A3. When I move the function in cell A3 to cell A10 it
still references cell A1. I want it to maintain the relationship it had and
reference the cell two rows above the new cell which would be cell A8.

When I copy the cell from once place to another I do not have this problem.
I only experiance this problem with I move a cell. How can I make a formula
that I can move all around and it will maintain a reference with a cell two
cells above the formula's cell?