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" <[email protected]> wrote in message
news:[email protected]...
> 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...
>>
>>
>>