Results 1 to 4 of 4

Thread: Remove blank in drop list

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-19-2015, 01:45 PM #2
    alansidman
    alansidman is offline
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    14
    1. Created a new Sheet3
    2. In cells A1:A4 entered list of four schools
    3. In Name Manager, defined list with Name "List"
    4. In Data Validation, changed look up to the defined "List"

    See attached.
    Attached Files Attached Files
    Alan
    Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
    Like my answer? Click * below
    Database Normalization
    Database Principles
    Pivot Table Tips
    Excel Video Tutorials
    SumProduct Video Tutorial
    DataPig Access Tutorials
    MS Query Tutorial
    SQL Tutorial
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. multi drop down list
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 03-04-2014, 07:36 AM
  2. Remove Unprintable Non-Blank Cells Having Zero Length Contents
    By aaronb in forum Excel Help
    Replies: 14
    Last Post: 08-06-2013, 02:53 AM
  3. Drop Down List Or Data Validation List To Insert Text In To Cell Range
    By regc in forum Excel Help
    Replies: 4
    Last Post: 07-27-2013, 01:34 PM
  4. How To Remove or Delete Blank Or Empty Rows After Data Is Transferred
    By jeff in forum Excel Help
    Replies: 5
    Last Post: 07-11-2013, 07:31 AM
  5. Remove Entire Row of Blank Cells in Column, Autofilter non-empty non-blank cells
    By sanmaya in forum Excel Help
    Replies: 2
    Last Post: 09-24-2012, 11:19 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
  •  

Forum Rules