Hi,

I wonder if you can help guys and gals.....

I have 2 spreadsheets. One has about 1000 rows, one has about 28,00
rows.

What I am doing is using a FOR statement to get the next row in th
smaller spreadsheet and then looping through the 28,000 records in th
other spreadsheet to find the matching row using another FOR statemen
that I have nested.
When it is found, it does some changes then exits the inner FO
statement.

Problem is, it takes FOR EVER! (pardon the pun!)

Any ideas as to how I can improve the speed? Here is a scaled dow
version of what I am doing!!!

For RowDates = Range("A1").End(xlDown).Row To 2 Step -1

strRef = Cells(RowDates, "A").Value
StrYes = Cells(RowDates, "B").value

For RDates = Range("A1").End(xlDown).Row To 2 Step -1
if Cells(Rdates, "A").Value = strRef then
' do something

exit for
else

end if
Next

Next



Help!!!

--
Message posted from http://www.ExcelForum.com