Simple manage of imported data

[Andrew MacDowell]

This is going to sound simple, but, I haven't found anywhere that
explains how to setup a spreadsheet in a template form and import data
from an out side source. The data records change from one record to
several records. I know how to import the data, and know how to
formate the cells, after the data is in the workbook. I was looking
for a automated way that would import the data, format the report, and
run formuls against the data in the rows and know when the end of the
data was.