AUTOMATING JOB SHEETS IN EXCEL

  • Thread starter Thread starter bobby smith
  • Start date Start date
B

bobby smith

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