+ Reply to Thread
Results 1 to 3 of 3

How can I change multiple cells at once to change where a formula references?

  1. #1
    Registered User
    Join Date
    05-31-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    6

    How can I change multiple cells at once to change where a formula references?

    I work for a tournament scheduling company and I am retrofitting our brackets in excel. I have written all the formulas but there are 50+ brackets to apply them to. Since the brackets change in size and shape so much I am having trouble finding a quick way to copy and paste formulas to different sized brackets without having to change a bunch of things for each one.

    I previously just manually dragged all the cells within the formulas but this takes far too long.
    I am trying out using the offset and indirect functions but I still end up having to use multiples of this so I still have to move a bunch of cells within the formula.

    Is there a way to make it reference the Indirect cell one time and use it multiple times so I would only have to move one reference?

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: How can I change multiple cells at once to change where a formula references?

    Can you attach a sample workbook showing what you expect as your results?

    Go Advanced -> Manage Attachments -> Upload

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: How can I change multiple cells at once to change where a formula references?

    You probably need to use 1 of the variations of ABSOLUTING

    $ is used to absolute a cell reference, locking it so that when copied, it doesnt change.. it comes in 3 different "flavors...

    $A$1 absolutes the entire cell reference, it will not chance when copied down or across
    $A1 absolutes only the column, "A" will not change when copied across, but "1" WILL change when copied down
    A$1 absolutes only the row, "1" will not change when copied down, but "A" will change when copied across
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] Change part of formula in multiple cells
    By T_BOLT in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-11-2015, 09:52 AM
  2. [SOLVED] Formula Fill to Cells: Only change certain cell references in a multi-reference forumla
    By deldalton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2013, 11:45 AM
  3. [SOLVED] Change references as you drag formula down
    By jeffreybrown in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-15-2013, 11:37 PM
  4. A way to get the cell references in a formula change
    By Michael6 in forum Excel General
    Replies: 9
    Last Post: 09-09-2009, 05:45 AM
  5. auto change cell formula on condition of worksheet change in other cells
    By futurejock in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-01-2009, 12:11 AM
  6. Change all cell references n cells to the right?
    By ModelerGirl in forum Excel General
    Replies: 4
    Last Post: 11-14-2006, 10:17 PM
  7. Replies: 0
    Last Post: 03-28-2006, 03:30 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