+ Reply to Thread
Results 1 to 5 of 5

duplicate text in empty cells along the column until new text appears in that column

  1. 01-04-2017, 05:28 PM #1
    aaaaa34
    aaaaa34 is offline
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    duplicate text in empty cells along the column until new text appears in that column

    Hey guys,

    Can you have a look at file please?
    I wanna copy text in every empty cells along column until new text appears in that column.
    Attached Files Attached Files
    Last edited by aaaaa34; 01-04-2017 at 05:34 PM.
    Reply With QuoteRegister To Reply
  2. 01-04-2017, 05:31 PM #2
    mikerickson
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: duplicate text in empty cells along the column until new text appears in that column

    Can you describe what you want?

    Perhaps

    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.
    Reply With QuoteRegister To Reply
  3. 01-04-2017, 06:15 PM #3
    aaaaa34
    aaaaa34 is offline
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: duplicate text in empty cells along the column until new text appears in that column

    can you add ur code with xlsm file pls?
    Reply With QuoteRegister To Reply
  4. 01-04-2017, 09:16 PM #4
    mikerickson
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: duplicate text in empty cells along the column until new text appears in that column

    Just put that code in your sub, it should work fine.
    Reply With QuoteRegister To Reply
  5. 06-23-2019, 07:01 AM #5
    aaaaa34
    aaaaa34 is offline
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: duplicate text in empty cells along the column until new text appears in that column 

    Please Login or Register  to view this content.
    Yes, it worked now with adding Sub lines in the code as above bro.
    Now i will mark it as solved.
    Thank you.
    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. Counting text only when specific text value appears in different column on same row.
    By CBD1989 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 09:08 AM
  2. [SOLVED] Sumif function to total column e if text in column a appears in more than one row
    By SMITH.CRYSTAL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-23-2015, 03:58 PM
  3. Help!4 - countif specific text from column A appears in column B & convert to a %
    By KClem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2015, 03:55 AM
  4. shift cells in column 2 spaces to right if specific text appears in that column
    By hosburgh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2014, 12:46 PM
  5. How to bring and copy row data of a cell text when the text appears in another column?
    By zori2012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2013, 05:23 PM
  6. Find duplicate text in cells in column, then give names of cells containing duplicate text
    By spelunkerforlife in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 10:13 AM
  7. how insert same text in empty cells in column (10000 rows)
    By bromptongadgets in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-11-2005, 11:15 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