Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintain Formula Reference (sort of) | Excel Worksheet Functions | |||
maintain worksheet reference | Excel Worksheet Functions | |||
Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
Getting a cell reference to move laterally instead of vertically? | Charts and Charting in Excel | |||
How do I reference the same cell as I move through range of cells. | Excel Worksheet Functions |