Results 1 to 4 of 4

Keep reference the same when cell referred to is moved.

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2014
    Location
    USA
    MS-Off Ver
    2007
    Posts
    2

    Keep reference the same when cell referred to is moved.

    Hello world,

    I have a bunch of cells that just show the values of cells in other Sheets in the workbook. However, the cells whose value is shown get cut and pasted a lot. Excel automatically follows the cells that are referenced rather than giving me the new data in the cells it is set to refer to. Let me give an example:

    Excel1.PNG
    Here the formula in cell B1 correctly displays the text "Test" from cell A1. However if I cut and paste A1 into B1, the formula changes:
    Excel2.PNG

    How can I get the formula in A2 to always refer to the location A1, even if A1 is moved somewhere else?
    Last edited by aschrag; 09-15-2014 at 01:00 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Protecting cell data from being referred in formulas
    By varun.kaul in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-03-2014, 11:07 AM
  2. [SOLVED] Is there a formula that allows you to reference the cell referred to in a UDF?
    By Excel2010101 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2014, 07:37 AM
  3. e cell referred to in a UDF?
    By Excel2010101 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2014, 01:15 AM
  4. [SOLVED] How to make a cell value dynamic when the referred value changes?
    By BNCOXUK in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-14-2013, 01:14 PM
  5. [SOLVED] Conditional format but referred from other cell
    By Lamb Chop in forum Excel General
    Replies: 2
    Last Post: 07-28-2006, 04:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1