wobblerthe1st
New Member
- Joined
- Jun 13, 2011
- Messages
- 1
Hi
I need a macro for Excel. I currently have a worksheet with five columns (A: customer number, B: name, C: workplace, D: Start date, E: Finish Date) each column holds data about a customer, one customer per row. this is called "Roll.xls"
I need a Macro thart will use this data to create a new workbook for each customer (holding all of this information) i.e a new workbook for each row of the original worksheet.
I want this workbook to be from a template i have created of a questionaire with several "True/False" checkbox's, called "Tracker.xls"
The new workbook needs to be saved under the customers name and number.
I'm sure its fairly easy to do but I'm lost having not really programmed in VBA before (and for that matter not programmed anything in aobut 15 years)
Any help is much appriciated
I need a macro for Excel. I currently have a worksheet with five columns (A: customer number, B: name, C: workplace, D: Start date, E: Finish Date) each column holds data about a customer, one customer per row. this is called "Roll.xls"
I need a Macro thart will use this data to create a new workbook for each customer (holding all of this information) i.e a new workbook for each row of the original worksheet.
I want this workbook to be from a template i have created of a questionaire with several "True/False" checkbox's, called "Tracker.xls"
The new workbook needs to be saved under the customers name and number.
I'm sure its fairly easy to do but I'm lost having not really programmed in VBA before (and for that matter not programmed anything in aobut 15 years)
Any help is much appriciated
