LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintain Formula Reference (sort of) JimK Excel Worksheet Functions 2 June 7th 06 05:14 PM
maintain worksheet reference inigo45 Excel Worksheet Functions 4 January 24th 06 10:49 PM
Copy worksheet & maintain cell reference across worksheets dingy101 Excel Worksheet Functions 3 January 2nd 06 10:51 AM
Getting a cell reference to move laterally instead of vertically? Melonhead Charts and Charting in Excel 1 November 2nd 05 08:04 PM
How do I reference the same cell as I move through range of cells. MikeShep Excel Worksheet Functions 1 February 7th 05 12:12 PM


All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"