+ Reply to Thread
Results 1 to 3 of 3

Autofilling While Controlling Which Values Change

  1. #1
    Registered User
    Join Date
    05-04-2020
    Location
    Somewhere
    MS-Off Ver
    365
    Posts
    2

    Autofilling While Controlling Which Values Change

    I'm trying to autofill data in Excel while controlling which values change. Here's a dummy version of what I'm trying to do:

    Excel.PNG

    I want the values for the C to be the sum of the value in A1 and each of the values in the B column. In other words, I want it to shift values for column B but not C. Of course I could fill all the values in Column A with 5, but for the cases I'm working on, those cells would have other values. Is there a way to do this? Thanks!

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Autofilling While Controlling Which Values Change

    You need to set cell A1 as a static cell address, e.g. $A$1.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Fill that down from C1:Cxx

  3. #3
    Registered User
    Join Date
    05-04-2020
    Location
    Somewhere
    MS-Off Ver
    365
    Posts
    2

    Re: Autofilling While Controlling Which Values Change

    Thank you! That's exactly what I was looking for.

+ 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] Autofilling multiple sheets with values on a control sheet
    By Dallas1000 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-13-2015, 04:03 AM
  2. Getting Change event to fire on pasting & autofilling list
    By dluga20 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2015, 09:03 PM
  3. [SOLVED] Error autofilling on change
    By mattdurbin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-29-2013, 11:25 AM
  4. [SOLVED] autofilling a column based on values on a row
    By goofer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-01-2013, 04:01 PM
  5. Excel 2007 : Controlling shape attributes from cells values
    By koval.andrey in forum Excel General
    Replies: 4
    Last Post: 09-21-2009, 10:01 AM
  6. Controlling shape formats by cell values
    By koval.andrey in forum Excel General
    Replies: 2
    Last Post: 09-03-2009, 06:43 AM
  7. When autofilling I would like to change worksheets rather than cel
    By tomsmithers in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2006, 08:08 AM

Tags for this Thread

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