you could use a query to retrieve the info you need form the text
files....

then construct the query with the proper joins to retrieve the correct
information in 1 sweep.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Cory Thomas wrote:

I have to run about 250,000 vlookups in one of my spreadsheets to make
sure that the correct data is being copied from the respective sheet.
As you can probably tell, this takes a LONG time, so i was wondering if
there would be a better approach to this problem.

I have 5 sheets total, sheet 2-5 are the ones with data (from dynamic
text files being imported at the start of the script) and sheet 1 is
where i have the vlookups that compare a value in cell B, and copies
the data if it matches.

1 More question, does excel have any easy way to have a timing method
to see how long my macros run (to see if my changes are making my
macros faster or slower).

Thanks
Cory


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