+ Reply to Thread
Results 1 to 4 of 4

Auto-fill cells until next value issue

  1. #1
    Registered User
    Join Date
    03-18-2020
    Location
    Dallas, USA
    MS-Off Ver
    2020
    Posts
    32

    Lightbulb Auto-fill cells until next value issue

    Hi Team, (Disclaimer, all names in attached file are fictitious)

    I have attached a .csv file that I need to talk about. If you can see in column A, there are names and blank cells below them until the next name.
    I need to auto-populate those names until the next name.

    Easy, all I do is:
    - Select column A
    - Go to special
    - Select blanks
    - press = and 'up' arrow and hit CTR+ ENTER which makes it apply to all names and blank cells in column A

    Sorted.

    HOWEVER, I sometimes need to delete that original name which then creates a #REF error because the formula ends up being broken.
    Is there a way to do the above but also get to delete the original cell?
    Last edited by TSACov; 07-16-2020 at 06:53 PM.
    Thanks!
    - TSACov

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,643

    Re: Auto-fill cells until next value issue

    After doing your Ctrl-Enter to apply the formula to the selected cells, then you should use Copy | Paste Special | Values | OK and then press the Esc key, in order to fix the values (i.e. to remove the formulae).

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    03-18-2020
    Location
    Dallas, USA
    MS-Off Ver
    2020
    Posts
    32

    Re: Auto-fill cells until next value issue

    It's so brilliant... but so simple!!!

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,643

    Re: Auto-fill cells until next value issue

    Glad to help - thanks for the rep, and for marking the thread as Solved.

    Pete

+ 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] Duplicate data for multiple cells by Auto Fill / Fill Down - Dynamic Table
    By ITY in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-23-2019, 09:57 AM
  2. Fill/Copy Down Blank Cells Issue
    By ptmuldoon in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-19-2016, 03:36 PM
  3. [SOLVED] Fill/Copy Down Blank Cells Issue
    By ptmuldoon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-05-2015, 08:36 AM
  4. Enter Key Issue & Auto Fill in Combobox
    By naveenmarapaka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2014, 05:44 AM
  5. Auto Fill Formula Issue PLEASE HELP!
    By j8cookie in forum Excel General
    Replies: 1
    Last Post: 10-10-2011, 02:40 PM
  6. Replies: 1
    Last Post: 09-07-2011, 05:57 PM
  7. Auto Fill Series issue...
    By e3donald in forum Excel General
    Replies: 3
    Last Post: 04-26-2006, 03:15 PM

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