complex update

Giganews Newsgroups
Subject: complex update
Posted by:  Stephen Simons (steve_IL…@pctamers.co.uk)
Date: Wed, 29 Oct 2003

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 steve_IL…@pctamers.co.uk

Replies