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 (e-mail address removed)
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 (e-mail address removed)