Have youtried to use in the Data Menu - Import. You may not need to write a
macro.

"SportyJim" wrote:

I have never attempted to write VBA code, but would like to know how to
import a report with data in a text file that is stacked that I want to
import to excel on one line in columns. Can someone help with this?