a) change the way the imported file is created so that it has one item per
record
b) do a Copy followed by Edit|Paste Special-Transpose in the worksheet
c) implement (b) as a subroutine macro
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jdicicco" wrote in message
...
I have a macro that imports text file. But the when the macro runs the
file
is imported accross the page. I need it to go down the page. This file
is a
daily update of accounting information.