How do I append imported text down an Excel Spreadsheet?

[Jdicicco]

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.

 

[Bernard Liengme]

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