Edit a List
Edit a List
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Edit a List

  1. #1
    Guest

    Default

     
    Suppose you have created an Excel list that contains many rows, each with 5 columns of data. Does Excel provide functionality that would allow you to examine the entire list and automatically delete all rows that contained empty cells in any of the 5 columns? I'm guessing a macro could be set up to do this - any tips on the code necessary?

  2. #2
    Guest

    Default

    On 2002-03-03 18:32, Anonymous wrote:
    Suppose you have created an Excel list that contains many rows, each with 5 columns of data. Does Excel provide functionality that would allow you to examine the entire list and automatically delete all rows that contained empty cells in any of the 5 columns? I'm guessing a macro could be set up to do this - any tips on the code necessary?

    Select the 5 columns
    Go to Edit>GoTo>Special>Blanks and click OK
    Go to Edit>Delete>EntireRow

    A macro can be created for the above with the macro recorder.

  3. #3
    Guest

    Default

      
    Bingo! That works like a champ - thanks VERY much!!!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com