Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching data thru 20000 records
Hi,
I have 2 sheets with several fields. on sheet1, i have new data and on sheet2 i have old data. i would like to update 2 fields of sheet1 with data from sheet2. for that i want to compare 3 fields, let's say C, D, E. if C, D, E are equal on sheet1 and sheet2, so i want to copy data from fields A and B (from sheet2) to fields A and B of sheet1. for now i use selection.autofilter ..... on the 3 fields to compare, but with my 20,000 records, it's really slow (on 3.1 Ghz CPU and 1 Ghz ram). So i would like to know if exists another way how to do it and for sure faster ? thanka a lot for help. maileen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching for records with multiple criteria | Excel Worksheet Functions | |||
Searching Latest Records | Excel Worksheet Functions | |||
Searching and displaying records that match criteria. | Excel Discussion (Misc queries) | |||
Searching for particular records | Excel Discussion (Misc queries) | |||
Searching for records that end in a specific character | Excel Programming |