K
KateW
Hi - I've been trying to find this answer by reviewing prior posts but what
I'm finding is either its not on point or too complex for me and I'm sure
there's a pretty easy way of doing this so pointers would be welcome. I'm
feeling stumped.
I need to compare two workbooks' data to see if they are the same; I'm
trying to test if a two queries return the same results and eliminate the
duplicate query. The data is in the exact same columnar layout with the same
headers. The data includes numbers and text. The data returned will not
always be unique as some matters, action (descriptions) and dates will repeat
over the date range reported on.
Column headers from left to right are
Action Due Date - returns a date
Action - returns a description of an action
Attorney - name
Docket Number - number
Country - text
Patent Master ID - number
Thanks,
KateW
I'm finding is either its not on point or too complex for me and I'm sure
there's a pretty easy way of doing this so pointers would be welcome. I'm
feeling stumped.
I need to compare two workbooks' data to see if they are the same; I'm
trying to test if a two queries return the same results and eliminate the
duplicate query. The data is in the exact same columnar layout with the same
headers. The data includes numbers and text. The data returned will not
always be unique as some matters, action (descriptions) and dates will repeat
over the date range reported on.
Column headers from left to right are
Action Due Date - returns a date
Action - returns a description of an action
Attorney - name
Docket Number - number
Country - text
Patent Master ID - number
Thanks,
KateW