+ Reply to Thread
Results 1 to 6 of 6

Delete rows that do not match items from listbox

  1. #1
    Registered User
    Join Date
    08-31-2013
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    15

    Delete rows that do not match items from listbox

    Hi all!

    Just like in the topic:
    I have a single-column listbox with a list of items and one column with data.
    What I need to do is to delete the row from the column if it doesn't match any item from the listbox.

    I know this problem might be very easy but I really can't solve it.

    Hope you have a moment for me!
    Thank you!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: Delete rows that do not match items from listbox

    What kind of list box is it?

  3. #3
    Registered User
    Join Date
    08-31-2013
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Delete rows that do not match items from listbox

    Quote Originally Posted by davesexcel View Post
    What kind of list box is it?
    It's a multi-select listbox. I thought it doesn't matter if I do not take selection into consideration.

    Here's what I've done.
    Please Login or Register  to view this content.
    Thank you!
    Last edited by pietras152; 10-07-2013 at 05:03 AM.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: Delete rows that do not match items from listbox

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  5. #5
    Registered User
    Join Date
    08-31-2013
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Delete rows that do not match items from listbox

    I'm sorry. It's not the first time I thought the problem is clear and nobody understood what I need.

    Now file with explanation attached.

    remove if not in the listbox.xlsm

    Thank you for your patience.

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: Delete rows that do not match items from listbox

    will the listbox always be populated from a range of cells?

+ 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. [SOLVED] Auto select items in a Listbox with items from another Listbox
    By perducci in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-22-2013, 04:45 PM
  2. Transfer random listbox items to new listbox and then loop through selected items
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 05:58 PM
  3. Delete Autofiltered rows from multi-column Listbox
    By kriswhiteley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2012, 08:46 AM
  4. Delete 3 items upon match?
    By Im2bz2p345 in forum Excel General
    Replies: 4
    Last Post: 05-12-2008, 12:59 PM
  5. [SOLVED] Delete rows that have data less than 20 items or less than value of £300
    By Crowbar via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2005, 05:05 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