Comparing to lists and extracting the difference
I have two lists which I would like to compare.
Sheet 1 = A List Sheet 2 - B List In Sheet 3 I would to use VB to write out all those items in the A list which are not in the B list. Thanks in Advance Matthew Balch |
Comparing to lists and extracting the difference
hi
use XL_Union.xla the way is A = select range ... A List B = select range ... B List XL_Union.xla option ----- A - B print option .... ON (what you want) Coloring option ----OFF or ON ( if On data will be colored ) find XL_Union.xla http://uno21.com/index2.asp?menu=forum&sub=work "Matthew Balch" wrote: I have two lists which I would like to compare. Sheet 1 = A List Sheet 2 - B List In Sheet 3 I would to use VB to write out all those items in the A list which are not in the B list. Thanks in Advance Matthew Balch |
All times are GMT +1. The time now is 08:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com