Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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... |
#2
|
|||
|
|||
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... |
#3
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparison / Check Off between 2 excel sheets. HELP NEEDED! | Excel Worksheet Functions | |||
How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
hot to access deleted information in excel sheets | Excel Discussion (Misc queries) | |||
need an advice in excel sheets.... | Excel Discussion (Misc queries) |