| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing the difference between 2 worksheets | Excel Discussion (Misc queries) | |||
| comparing worksheet and Marking the difference | Excel Worksheet Functions | |||
| Comparing two lists and extracting data from one to another | Excel Worksheet Functions | |||
| Comparing files and extracting info. | Excel Worksheet Functions | |||
| Comparing Lists to Partial Lists | Excel Programming | |||
![Matthew Balch[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
