I am trying to export data into an excel spreadsheet. Is there a way using
VBA to automatically set up the sheet and have the data import? Or would I
have to use commands such as List Columns and List Rows?

Any help will be appreciated.