+ Reply to Thread
Results 1 to 3 of 3

Columns that are dependent on each other without circular reference

  1. #1
    Registered User
    Join Date
    08-07-2014
    Location
    Aberdeen
    MS-Off Ver
    2010
    Posts
    2

    Columns that are dependent on each other without circular reference

    Hi guys,

    I have two columns of data; one is in inches, one is in metres. If someone is inputting data from an original source that has the data in metres I want excel to automatically calculate and input the data into the inches column. Additionally, if they input the data from the source in inches, I want excel to convert it to metres and input into the other column automatically. The conversion factor from inches to metres is * by 0.0254.
    I am no expert but after looking for this on the internet I am sure this requires some sort of VBA event code (although I don't really know the first thing about VBA). The excel columns will be in the same worksheet. Would someone be able to help me with this so I don't have a circular reference like I would do using normal Excel formula? I am using Excel 2010.

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Columns that are dependent on each other without circular reference

    Hi,

    Welcome to the Forum.

    This might be an alternate way, I have created 2 output columns based on the chosen input type in the attached file. Please see if it suits your requirement
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-07-2014
    Location
    Aberdeen
    MS-Off Ver
    2010
    Posts
    2

    Re: Columns that are dependent on each other without circular reference

    Thanks for your quick response.

    Unfortunately this is quite a large excel sheet with a pivot table and further formulae relying on the data. If I use the method that you have described, with every change of the input type, the other cells using the metres/inches cells will change due to the formula dependencies.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 02-23-2014, 06:06 PM
  2. 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
  3. Replies: 1
    Last Post: 08-21-2007, 07:22 PM
  4. 'circular reference'
    By Rathika in forum Excel General
    Replies: 2
    Last Post: 01-26-2006, 12:30 AM
  5. [SOLVED] circular reference in VB
    By filo666 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2005, 01:07 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