Closed Thread
Results 1 to 3 of 3

Help with a possible circular reference

  1. #1
    Registered User
    Join Date
    02-03-2017
    Location
    Houston, TX
    MS-Off Ver
    365
    Posts
    2

    Help with a possible circular reference

    I have a general question about excel that is a little complicated to explain so I'm going to try my best. This is something I've been doing for years and have always thought that there has to be a better way. What I am trying to do is manipulate the value of cell a IN CELL A. Of course if I do this I get a circular error. I'm trying to figure out a work around and I can't imagine that I am the only person who thought the correct way of doing this is far too inefficient.

    cell a
    VALUE

    cell b
    manipulation of cell a

    After manipulating the value of cell a in cell b, I have to copy and paste the value of cell b in cell b to write over the formula
    Then I do a cell a = cell b formula
    then I copy and paste the new value of cell a in cell a, again to overwrite the formula with the value
    then I can safely delete cell b

    Is there a better way other than writing a macro?
    Last edited by Scubabuddy; 02-03-2017 at 08:17 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,637

    Re: Help with a possible circular reference

    Duplicate post: http://www.excelforum.com/showthread.php?t=1172593
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,035

    Re: Help with a possible circular reference

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. its NOT a circular reference!!!
    By dosmastr in forum Excel General
    Replies: 9
    Last Post: 01-11-2016, 01:14 AM
  2. Replies: 2
    Last Post: 02-23-2014, 06:06 PM
  3. Circular Reference
    By sciartilli in forum Excel General
    Replies: 4
    Last Post: 03-11-2012, 09:16 PM
  4. Circular Reference when formulas reference end of row formula!
    By Spellbound in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-29-2009, 08:26 AM
  5. Replies: 1
    Last Post: 08-21-2007, 07:22 PM
  6. [SOLVED] Circular reference help please!
    By steve@stuff2send.co.uk in forum Excel General
    Replies: 1
    Last Post: 02-09-2006, 06:45 AM
  7. Circular Reference-How can this be possible?
    By munim in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-05-2006, 04:36 AM

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