Results 1 to 13 of 13

Macro to find blank cells, copy row, paste into another worksheet, then delete

Threaded View

  1. #1
    Registered User
    Join Date
    04-14-2011
    Location
    Bay Area, CA
    MS-Off Ver
    Excel 2007
    Posts
    32

    Macro to find blank cells, copy row, paste into another worksheet, then delete

    Hi,

    So I have 3 columns of data (Column A, B, C). Column C has some blank cells in it. I would like to be able to find all the blank cells in Column C, then copy the rows (Column A, B, C) which contain the blank cells, paste them into another sheet within the same workbook, then delete them from the original sheet.

    using the macro recorder I was able to do this:

    Sub Macro4()
    '
    ' Macro4 Macro
    '
    '
    Columns("C:C").Select
    Selection.SpecialCells(xlCellTypeBlanks).Select
    Selection.EntireRow.Delete
    End Sub

    Obviously, this finds the cells which are blank & allows me to delete those rows containing the blank cells in the SAME worksheet. I still have not figured out the way to copy them to another sheet before deleting them.

    Is the current macro a good starting point to expand on, or should I try a totally different approach?

    Thanks in advance,
    Rob
    Last edited by rbrookov; 10-15-2013 at 10:05 AM. Reason: Marked as "SOLVED"

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] vba to copy non blank cells and paste to other worksheet
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 06:22 PM
  2. I am in deperate need of a macro to find blank cells in a column and delete the row
    By leon1233 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2013, 05:57 PM
  3. [SOLVED] Copy row of data, paste in another worksheet, delete some of the cells copied
    By dev111ski in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-14-2012, 05:58 PM
  4. Copy and paste macro-blank cells thereafter.
    By Bikernick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2006, 12:00 PM
  5. Macro copy and paste = blank worksheet
    By efface in forum Excel General
    Replies: 1
    Last Post: 04-27-2006, 04:52 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