AUTOMATING JOB SHEETS IN EXCEL
 

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...

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...

Thanks Cassie,
but I am a little new with Excel. I know my way around it and can create a
macro aswell. However would I need to write this in VBA or some other
language? Are there are any snippits of code I can obtain from some place to
achieve this rather then reinventing the wheel ? How do I code a for each
next statement? sorry for all these questions but at the expense of sounding
stupid I have never coded a macro before that does anything as complex any
further advice or point in the right direction would be majorly appreciated.

thanks in advance.

Bobby

"Kassie" wrote in message
...
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...