Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two workbooks that has almost same lists (range(a1:z18000)
some of the data are the same, and i want to transfer from the secont workbook all the data that are not the same. The column that i want to compare is column(2) And if the value in workbook(1).worksheet(1).cell (a,2) it exists in target workbook(2).worksheet(1) do nothing. If it doesn't then copy the entire row to the last empty row in target workbook(1).worksheet(1). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
compare lists | Excel Discussion (Misc queries) | |||
Compare lists in Multiple workbooks | Excel Worksheet Functions | |||
compare name lists | Excel Worksheet Functions | |||
Compare Lists | Excel Discussion (Misc queries) | |||
Compare Lists | Excel Programming |