|Posted by:||Stephen Simons (steve_IL…@pctamers.co.uk)|
|Date:||Wed, 29 Oct 2003|
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.
remove "_ILY_" to email me
email to steve_IL…@pctamers.co.uk