Hi bobby smith

Of course it can be done. You need to record a macro to do it, using a for
each .. next statement. Basically you need to have the macro count the used
rows, and then repeat a set of code for each row.

"bobby smith" wrote:

Hi all,
I have a lot of customer data for job sheets that need printing out.
I was wondering would anyone know if it would be possible for Excel to read
in a data file, or even another excel spreadsheet and for each record/row
create a new Job Sheet. Otherwise I have to manually create one job sheet
for each row of customer data I have.
Can I automate this so Excel reads one row/record then writes or creates a
jobsheet, then does the same iteratively till it reaches the end of the
row(s)/record(s).
Any help on this would be much appreciated good folk .
:)
Sonny...