Can you attach a coppy of the data to be imported?
That way I will be able to create a macro to import the data and forma
it the way you want.
Or if not, can you send a sample of the file you want changed

--
bgeie
-----------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...fo&userid=1282
View this thread: http://www.excelforum.com/showthread.php?threadid=54570