+ Reply to Thread
Results 1 to 3 of 3

Copy Non Blank Lines to new worksheet appending to first blank line

  1. #1
    Registered User
    Join Date
    01-18-2011
    Location
    Somerset
    MS-Off Ver
    Excel 2010
    Posts
    28

    Copy Non Blank Lines to new worksheet appending to first blank line

    Hi,

    I would appreciate your help with the following.

    I want to copy and paste lines in Sheet1 which have a value in column B to a new worksheet (Sheet2), appending them on the first blank line.

    Data to be copied if condition is met......Column A, B & C for each row where B is not NULL

    Paste into Sheet2, on the first blank line (A into A, B into B and C into C)

    In my example rows 2 and 5 would copy (Apple and Orange)

    Thanks in advance.
    Attached Files Attached Files
    Last edited by stephboucher; 01-24-2021 at 07:26 AM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: Copy Non Blank Lines to new worksheet appending to first blank line

    Try
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-18-2011
    Location
    Somerset
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Copy Non Blank Lines to new worksheet appending to first blank line

    Perfect!!!! Thanks so much !!!!

+ 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: 07-30-2019, 11:03 AM
  2. Macro to Copy cells from line below whenever there's a blank line
    By seanomuiri in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2018, 12:40 PM
  3. Replies: 2
    Last Post: 10-15-2018, 10:46 AM
  4. Hiding/Deleting Lines based on blank/not blank
    By MIKE A 101 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2018, 05:31 PM
  5. [SOLVED] Concatenate If Blank - remove blank line if first cell is blank
    By ker9 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2014, 02:14 PM
  6. [SOLVED] Macro to Insert Blank Line and Sum Above Lines
    By cgomez04 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2012, 10:02 AM
  7. Replies: 0
    Last Post: 02-09-2012, 11:53 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1