Results 1 to 3 of 3

UserForm - Summarize Unique Values from Two Columns

Threaded View

yaddles UserForm - Summarize Unique... 04-20-2017, 07:55 AM
dflak Re: UserForm - Summarize... 04-20-2017, 12:13 PM
yaddles Re: UserForm - Summarize... 04-21-2017, 09:00 AM
  1. #1
    Registered User
    Join Date
    01-14-2014
    Location
    perth
    MS-Off Ver
    Excel 2010
    Posts
    10

    UserForm - Summarize Unique Values from Two Columns

    Hi there,

    I am quite terrible with Macros/VBA, and have recently purchased a sizable tome on the subject. In the meantime, I would be most appreciative for help on the following:

    Scenario:
    I am trying to create a UserForm (or similar) that summarizes the non-duplicate values from one column compared with another column. This summary is to have the option of selecting the values, and then have them added to the primary list.

    Detailed Request:
    The UserForm (or pop-up) is to list values that are in Column B, but not in Column A.

    The UserForm is to have a check-box (or selection method) next to each listed value. The number of values will vary, and subsequently so must the number of check-boxes.

    The UserForm is to have a button.

    If check-boxes are checked, and the button pressed, the checked values are to be appended to Column A.

    The UserForm window will only appear if values exist in Column B that are not in Column A.

    Thank you for your help, and suggestions,

    Yaddles
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Unique Values in Combobox in Userform
    By nKife in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2015, 07:45 PM
  2. Summarize values in Pivottable for multiple columns
    By ammartino44 in forum Excel General
    Replies: 0
    Last Post: 02-17-2015, 02:51 PM
  3. [SOLVED] Find count of Unique or Duplicate Values based on Concatenated values in 2 columns
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2014, 12:42 AM
  4. Userform: Unique Values to ComboBox
    By dinosaur1993 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-21-2013, 03:09 AM
  5. [SOLVED] userform combobox2 does not have unique values and will not fill listbox
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2013, 12:22 PM
  6. 3 columns: None contain unique values, but I need a list of every unique set
    By mathematician in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-15-2012, 04:47 PM
  7. Count Unique values and summarize totals
    By MattG in forum Excel General
    Replies: 3
    Last Post: 06-26-2009, 04:59 PM

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