+ Reply to Thread
Results 1 to 6 of 6

How to fill down formula to next used cell

  1. #1
    Registered User
    Join Date
    01-20-2015
    Location
    london
    MS-Off Ver
    2010
    Posts
    33

    How to fill down formula to next used cell

    Hi, looking to know how to copy a formula in e.g. a1 down blank cells until e.g. A10 where A10 contains a value of word. Therefore code would populate cells a2 to a9.
    Or can a range range be made to be dynamic as rows will be added or deleted and the formula needs to fill colum A1 between headers and footers etc.
    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,729

    Re: How to fill down formula to next used cell

    See next code
    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Contributor
    Join Date
    09-19-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    208

    Re: How to fill down formula to next used cell

    If you have a formula in cell A1, and another value/formula in A10, you can easily fill A1's formula down through A9.

    Hover over the lower-right corner of cell A1 until the cursor changes to a + sign. At that point, double-click and your formula will automatically fill down through any unused cells.

  4. #4
    Registered User
    Join Date
    01-20-2015
    Location
    london
    MS-Off Ver
    2010
    Posts
    33
    Hi,
    This needs to be done via vba as it's part of sheet automation!

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,607

    Re: How to fill down formula to next used cell

    Quote Originally Posted by \_(ツ)_/ View Post
    ... formula will automatically fill down through any unused cells ...
    Only if there is data in an adjacent column (unless it has changed in later versions than I am using).

    Pete

  6. #6
    Forum Contributor
    Join Date
    09-19-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    208

    Re: How to fill down formula to next used cell

    Good point, Pete.

    As for automation, you can use PCI's code, or even shorten that to just
    Please Login or Register  to view this content.

+ 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: 4
    Last Post: 05-04-2015, 12:58 AM
  2. Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  3. To fill entire row with fill colour of a particular cell with a formula
    By shailendra chari in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 11-30-2013, 11:18 AM
  4. [SOLVED] Formula to fill a cell based on drop down list in previous cell
    By formatting freak in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-03-2013, 01:18 AM
  5. Replies: 5
    Last Post: 03-20-2013, 12:30 PM
  6. Formula to Automatically Fill Blank With Next fill cell's data?
    By VMoney in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-22-2013, 05:11 PM
  7. Replies: 1
    Last Post: 09-07-2011, 05:57 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