| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create files from a spreadsheet
Each month I need to create a separate excel file for each customer with an
accounting of errors I have a template with 6 fields that need I enter data into. I then save the file and e-mail it to the customer for corrections. I have another speadsheet that contains the data for each of the 6 fields that I am entering. Can anyone explain how to automate this process? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create files from a spreadsheet
Hi PetNetwork
Why not create 6 sheets(for every customer ) and link(formula) to the information in the other workbook You can use a macro like this then to mail if you also enter the mail address in each sheet http://www.rondebruin.nl/mail/folder1/mail5.htm -- Regards Ron De Bruin http://www.rondebruin.nl "PetNetwork" wrote in message ... Each month I need to create a separate excel file for each customer with an accounting of errors I have a template with 6 fields that need I enter data into. I then save the file and e-mail it to the customer for corrections. I have another speadsheet that contains the data for each of the 6 fields that I am entering. Can anyone explain how to automate this process? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Read 3 txt input files and create an XL spreadsheet | Excel Discussion (Misc queries) | |||
| create .xlk files | Excel Discussion (Misc queries) | |||
| how to create xls from CSV files | Excel Programming | |||
| create help files! | Excel Programming | |||
| create TEXT files for EACH row in EACH xls Spreadsheet | Excel Programming | |||
Linear Mode
