Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to append data from different sheet and different workbook?
Hi Guys,
Which is the best way using excel VBA to combined non duplicate data from different sheets and different workbook? For example I have 2 workbook, workbook 1 and workbook 2. They have similar worksheet with similar header. Now my mission to copy data from workbook 2 into workbook 1 but for non duplicate data. Meaning if the data in workbook 2 found in workbook 1 then skip else copy this data below. In my mind now I will copy all data from workbook 2 and append below inside workbook one then sort to delete duplicate row but it seem too slow. Is there any other way which is more faster .Please help with VBA code. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to append data from different sheet and different workbook?
Your excel version. Layout example compare 1 column only or 2+ .
Details!! On Feb 3, 10:04*am, geniusideas wrote: Hi Guys, Which is the best way using excel VBA to combined non duplicate data from different sheets and different workbook? For example I have 2 workbook, workbook 1 and workbook 2. They have similar worksheet with similar header. Now my mission to copy data from workbook 2 into workbook 1 but for non duplicate data. Meaning if the data in workbook 2 found in workbook 1 then skip else copy this data below. In my mind now I will copy all data from workbook 2 and append below inside workbook one then sort to delete duplicate row but it seem too slow. Is there any other way which is more faster .Please help with VBA code. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to append data from different sheet and different workbook?
should compatible with 2003 and 2007. compare with multiple column
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i append data to a sheet or book from another one | Excel Programming | |||
How to Append data in excel sheet | Excel Programming | |||
Append info in all worksheets in workbook in one sheet | Excel Programming | |||
append data to other workbook | Excel Programming | |||
Append data to a separate workbook | Excel Programming |