Hi all, new member here.
I'm working with a query tool that generates lists of data and exports to Excel worksheets. A certain query I'm working on right now returns a list of over 2700 line items, and each of these items needs to be examined manually...
Based on a search criteria, I'm able to use a filter to query a list of over 700 items that are part of the original query, but do not need any attention.
Question: How can I subtract the ~700 items in the second query from the original query list? Each query exported to Excel generates a new worksheet. No, the query tool does not have the ability to filter out these line items on its own.
Thanks!
P.S. I'm not a deeply skilled user, so I need things in layman's terms!
EDIT: Each query outputs a new workbook, not a worksheet.
Bookmarks