| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare 2 col listings n append items in A not in B to bottom of B
In Sheet1 (the codename)
In B19 down is a list of unique items: xx yy zz In Sheet2 (the codename) In A3 down is another list of unique items: aa yy bb I need a sub to compare the 1st list with the 2nd, and to append any items in the 1st which are not found in the 2nd list, to the bottom of the 2nd list. Example, for the sample data above, the 2nd list should finally look like this: aa yy bb xx zz (xx, zz are appended) The sub is to reference the 2 codenames Thanks for insights |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter data by top 10 AND bottom 10 items simultaneously | Excel Worksheet Functions | |||
| How to have a the liist items appear at the top, not bottom | Excel Worksheet Functions | |||
| Moving Items to bottom of spreadsheet based on criteria | Excel Programming | |||
| Compare ranges n copy at bottom of first range | Excel Programming | |||
| Compare and Append | Excel Programming | |||
Threaded Mode
