Results 1 to 10 of 10

Picking Different Items Between Two Lists and Creating a New List

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-27-2004
    Location
    California, United States
    MS-Off Ver
    Excel 2016
    Posts
    317

    Picking Different Items Between Two Lists and Creating a New List

    I have been reading posts about comparing lists for a couple of hours now but I have not found a post that will deal with my issue (or if I did read it, it was not obvious to me).

    Each Monday I run a query in our master Access database to get a subset of items specifically for my needs. Each week this list of items will grow (by the end of the year it could be anywhere between 4K - 10K items). During the week, I will run the same query but it will contain items that have been entered late. I need to be able to pick out these late items and create a new list of them.

    In the attached sample workbook (I have removed all of the sensitive cells and have just left the columns I need to work with). I have the first tab which will give me a summary (just a count) of the late items and this is also where I would like to have a list generated of the different items that are on tab 2 but not on tab 3. On the second tab, I have the query results from today (Wednesday). On the third tab, I have the query results from Monday. On the fourth tab, I paste a report which has several numbers I use but I have only left one of them in this sample workbook which is relevant to this task.

    Thank you in advance for any assistance on this.
    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. Replies: 4
    Last Post: 06-30-2014, 11:13 AM
  2. [SOLVED] Creating a grocery list in a new worksheet based on selected items in a master list
    By jacolli4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2012, 07:53 AM
  3. Randomly picking unique items from a list.
    By corrado33 in forum Excel General
    Replies: 1
    Last Post: 10-23-2010, 12:19 AM
  4. Combine two lists into a list of unique items
    By mkvassh in forum Excel General
    Replies: 4
    Last Post: 03-26-2010, 03:27 AM
  5. Creating lists of unique items
    By alexander in forum Excel General
    Replies: 2
    Last Post: 04-10-2005, 10:13 AM

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