regarding your query about what if there are two instead of 3 files.
well do your files have a set name. eg. you get 3 files each month are
they sent in like FileA.xls, FileB.xls, FileC.xls or are they FileA
January 2006.xls fileb February 2006.xls etc?
--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread:
http://www.excelforum.com/showthread...hreadid=540905