+ Reply to Thread
Results 1 to 4 of 4

Adjusting Formula For Newly Inserted Column

  1. 01-13-2016, 01:32 PM #1
    general_excel
    general_excel is offline
    Registered User
    Join Date
    05-23-2014
    Posts
    2

    Adjusting Formula For Newly Inserted Column

    I have a sheet to monitor course fill rates. The fill rate is calculated by dividing the enrollment cap by the actual enrollment number. Each day a column is added to the sheet to reflect the current enrollment numbers. Is there a way for the formula to automatically change to the new column?

    Any help would be much appreciated!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-13-2016, 02:24 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Adjusting Formula For Newly Inserted Column

    Here's what your data looks like:

    Data Range
    A
    B
    C
    D
    E
    1
    Course Name
    Enrollment Cap
    1/11 Enrollment
    1/12 Enrollment
    Fill Rate
    2
    College Algebra
    35
    18
    22
    51.43
    3
    Statistics
    24
    19
    24
    79.17
    4
    Calculus
    30
    25
    38
    83.33


    Where is the new column being added?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 01-13-2016, 02:30 PM #3
    dosydos
    dosydos is offline
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Adjusting Formula For Newly Inserted Column

    in column E
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 01-13-2016, 03:14 PM #4
    general_excel
    general_excel is offline
    Registered User
    Join Date
    05-23-2014
    Posts
    2

    Re: Adjusting Formula For Newly Inserted Column

    Quote Originally Posted by dosydos View Post
    in column E
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Thank you, that is perfect! I appreciate the help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula not working in a newly inserted row
    By Brenda H in forum Excel General
    Replies: 18
    Last Post: 09-06-2015, 09:14 AM
  2. [SOLVED] Unmerge Cells and Fill down the Values in newly inserted Column
    By prkhan56 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2014, 11:21 PM
  3. [SOLVED] Put Formula in newly inserted cells
    By sunjam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2014, 02:51 AM
  4. [SOLVED] Macro/VBA to keep formula in newly inserted row
    By Antligen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-11-2014, 06:32 AM
  5. [SOLVED] Create a Macro to paste formula into newly inserted row
    By simple? in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-27-2013, 04:47 PM
  6. vba to insert new row AND highlight NEWLY INSERTED ROW
    By wanty in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2013, 11:56 PM
  7. Formula to span newly inserted columns?
    By mikep7779 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2010, 09:44 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1