complex update

S

Stephen Simons

Help!

I have an excel 2000 dbs that needs updating regularly.

The dbs is 40 cols wide and looks into two input files, doing some complicated "IFs" and "VLOOKUPs" , pulling info from
one or the other, depnding on the IF & lookup.

My problem is: it takes a L O O O O N G time to run.

My question is: does anyone have any ideas how to speed it up, or maybe could suggest a different approach?

Many thanks in advance.

Steve
remove "_ILY_" to email me

email to [email protected]
 
Top