That's one big question. The simple bit to answer is that you can do it
easily with all versions of Excel from '97. (can't remember what it was
like in 95 and it was a bit of a sod in V5)

As to how need to be a bit clearer as to what you are really trying to
do : pulling in lots of data, a few choice numbers where is the data
held etc.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=490768