+ Reply to Thread
Results 1 to 6 of 6

VB Code to copy and delete blank rows

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to copy and delete blank rows

    Hello:

    Please refer to attached file.
    I have check entry as shown in Sheet "CheckEntry"
    I need VB Code :
    1: To copy the data from Column A:F and paste in Sheet2 at cell C1.
    2: Once copied in Sheet2, need to delete the rows with zero or blank in column F.

    I have manually copied from Checkentry into Sheet2.
    I have also highlighted which rows needs to be deleletd.

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: VB Code to copy and delete blank rows

    Hi rizmomin,

    Though I'm sure I've answered very similar questions you've had like this before, this should do the trick:

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to copy and delete blank rows

    Hi Trebor76:

    Thanks a lot for great help..
    Works great.
    Riz

  4. #4
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to copy and delete blank rows

    Hi Trebor76:

    I saw one problem when i use in my sheet.
    It copies the macro button which i have, please look at the attached pic after copying...
    Riz,,
    Attached Images Attached Images

  5. #5
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to copy and delete blank rows

    Hi Trebor76:

    I have resolved the problem with the following code...Thanks

    Please Login or Register  to view this content.
    Riz

  6. #6
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: VB Code to copy and delete blank rows

    I have resolved the problem with the following code...Thanks
    You're welcome. I'm glad we got it all sorted

+ 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. Need Code to look for blank rows and copy one cell to another
    By fauncefus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2014, 07:44 PM
  2. Using code to delete rows with blank cells in them upon opening the workbook
    By marielouise1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2014, 02:00 PM
  3. Changing code from deleting rows to cut/paste rows into another sheet and delete blank row
    By kmarshall6576 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2013, 01:54 AM
  4. Copy single row to new worksheet / delete blank rows
    By stevejfice in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-28-2011, 09:21 AM
  5. Code to delete all blank rows and add totals
    By fusion007 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-24-2011, 04:00 PM
  6. Delete rows if column contains a blank code included
    By v3x0rg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2010, 10:01 AM
  7. Code to delete partial rows based on blank cells
    By scaffdog845 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2010, 04:15 AM
  8. Replies: 1
    Last Post: 06-20-2009, 03:43 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