+ Reply to Thread
Results 1 to 9 of 9

Display items from list that weren't selected in another column

  1. #1
    Registered User
    Join Date
    01-11-2023
    Location
    Stockport, England
    MS-Off Ver
    365
    Posts
    8

    Display items from list that weren't selected in another column

    Hi

    Any help is much appreciated, please.

    I have a spreadsheet where I have 2 columns that have lists in them, I've enabled a VBA macro so that I can select multiple options from the drop down.

    I've attached my spreadsheet, in column 'F' I will select all the information that has been provided. In column G I want to list all the items that weren't selected from the original list so that I can perform a gap analysis much easier. Is it possible to set a formula to do this?

    please let me know if there's any further info you require to answer my question. All responses are much appreciated, thank you in advance.BG ACC track.xlsmBG ACC track.xlsm

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Display items from list that weren't selected in another column

    Slight mod to ws change handler:
    Please Login or Register  to view this content.
    Build missing item list:
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    01-11-2023
    Location
    Stockport, England
    MS-Off Ver
    365
    Posts
    8
    Thank you so much for this. Do I just paste the attached coding underneath my current VBA coding? Thank you


    Quote Originally Posted by protonLeah View Post
    Slight mod to ws change handler:
    Please Login or Register  to view this content.
    Build missing item list:
    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Display items from list that weren't selected in another column

    Put the new code: Sub MissingInfo(), in a new module
    you should replace your original 'change module with the one I posted.

  5. #5
    Registered User
    Join Date
    01-11-2023
    Location
    Stockport, England
    MS-Off Ver
    365
    Posts
    8

    Re: Display items from list that weren't selected in another column

    Thank you so much, that does exactly what I want. It's only applied it to F3 and G3 though, how do I apply it to the entire column please?

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Display items from list that weren't selected in another column

    OK. I added a variable to hold the address of the active cell in column F (Active_F).
    This address will be passed to the MissingInfo. The hard coded F3 & G3 are replaced using Active_F value.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by protonLeah; 01-12-2023 at 04:33 PM.

  7. #7
    Registered User
    Join Date
    01-11-2023
    Location
    Stockport, England
    MS-Off Ver
    365
    Posts
    8

    Re: Display items from list that weren't selected in another column

    Sorry to keep bothering you. it doesn't work at all any more, even if i use your original code, it isn't working like it was, i can't select multiple options and it isn't listening the items that aren't selected, i've attached my spreadsheet again so you can see how i've done the VBA but i have no idea what's wrong with it, if you can help at all pleaseBG ACC track 2.xlsm

  8. #8
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Display items from list that weren't selected in another column

    Your last attachment is working for me.

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: Display items from list that weren't selected in another column

    If the code has crashed at some point, I suspect you have disabled event handling.

    In the Immediate window, type Application.EnableEvents = True and press Enter. Then try again.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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] Display Items of selected Category
    By plans in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2019, 08:24 PM
  2. button click to move selected multi-column list box items to new list box
    By kranic3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2017, 08:34 AM
  3. To create a list of items in which certain items can be selected and printed
    By swashbuckler in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-05-2017, 01:26 PM
  4. UserForm ComboBox ONLY display selected items in List
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-16-2015, 01:02 PM
  5. Replies: 1
    Last Post: 04-20-2013, 02:45 PM
  6. Replies: 1
    Last Post: 09-03-2012, 10:03 PM
  7. Replies: 1
    Last Post: 06-24-2005, 12:21 AM

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