+ Reply to Thread
Results 1 to 2 of 2

Need help on deleting rows . Please see inside.

  1. #1
    quekou
    Guest

    Need help on deleting rows . Please see inside.

    I have a worksheet with 4 columns and about 600 rows. The A,B,C columns have
    contents in all their cells. Only a few cells have contents in Column D. What
    I need to do is to delete all the rows with it's respect D column cell blank.
    In other words, I am going to just keep all the the rows only when their D
    column cells have contents. It would be impossible to inspect each row to see
    it's column D cell is blank and delete the row. Could anyone provide me with
    a solution, maybe it's just a simple macro. But it has mystified me for 2
    days now. Thank you in advance.

  2. #2
    Forum Contributor
    Join Date
    12-14-2005
    Posts
    176
    Go to MENU BAR - DATA - FILTER - AUTOFILTER and then on Column D - Filter for "BLANKS" - Select your rows and "DELETE."
    Do this with a COPY incase you do not get the results you want.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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