Results 1 to 6 of 6

how to stop auto adjusting formulas when insert reference column

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2014
    Posts
    2

    how to stop auto adjusting formulas when insert reference column

    A1 reads =+(B1+C1)/C1 where B1 represents 'the current month' and C1 represents 'the previous month'. The formula in A1 shows me the change between the current and previous months. Each month I want to insert a new column between A and B, and, I want the formula in A1 to remain as =+(B1+C1)/C1.

    I've tried different things, but it seems no matter what I do, when I insert a column between A and B, the formula in A1 changes to =+(C1+D1)/DC1

    Any thoughts?
    Thank you.

    Joe
    Last edited by mystockpick; 06-01-2014 at 09:13 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto-recalculate reference formulas when the reference is changed?
    By mstieler in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-25-2013, 01:53 PM
  2. Auto adjusting column width causing issues
    By ericaop in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2013, 08:39 AM
  3. Auto insert new row with formulas
    By timber4483 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-25-2011, 12:48 PM
  4. Adjusting code to check column, and insert formula
    By oOarthurOo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2010, 01:50 PM
  5. deleting a worksheet and auto adjusting formulas
    By bobbak in forum Excel General
    Replies: 6
    Last Post: 09-11-2009, 11:23 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