| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 72459 | 2006-09-13 21:12:00 | Creating Multiple Files in Excel | GrahamB (750) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 484407 | 2006-09-13 21:12:00 | I have a need to create a numerical sequence of files based on a Master Spreadsheet file. Is there an easy way to do this other than one at a time? TFYH Graham Bockett |
GrahamB (750) | ||
| 484408 | 2006-09-14 02:17:00 | Yes thats possible Graham with VBA code which I could write for you if you want. What data is being written to the files or are you meaning to make multiple copies of an Excel file but just with lots of different names? regards, Graham |
Parry (5696) | ||
| 484409 | 2006-09-18 12:07:00 | Hi Parry I have written a file in Excel which I plan to use as a Job Sheet. Each sheet needs to be sequentially numbered, either literally, or as a YearMonthNumber system (0610001,0610002, etc).Part of the sheet will include a LOOKUP formula back to a separate spreadsheet file. Because more than one person will be accessing the Job Sheets on a network, they need to be separate files rather than multiply sheets within a file. Will certainly appreciate your assistance. If you wish to send a file directly, please email to graham@chl.co.nz Regards GrahamB |
GrahamB (750) | ||
| 484410 | 2006-09-18 19:37:00 | Hi Parry I have written a file in Excel which I plan to use as a Job Sheet. Each sheet needs to be sequentially numbered, either literally, or as a YearMonthNumber system (0610001,0610002, etc).Part of the sheet will include a LOOKUP formula back to a separate spreadsheet file. Because more than one person will be accessing the Job Sheets on a network, they need to be separate files rather than multiply sheets within a file. Will certainly appreciate your assistance. If you wish to send a file directly, please email to graham@chl.co.nz Regards GrahamB Hi Graham, it shouldnt be too hard to do for you. The nature of code is that you need to be specific about what actions you take so while I could create an example and send it to you it would have to be adapted to suit your layout. Im not sure if you know any VBA so its best if you send your file to me with instructions on which sheet you want to use as the job sheet and where the number should go. If it contains sensitive info like names and addresses then just type in dummy values. My email is parryishere@yahoo.com.au regards, Graham |
Parry (5696) | ||
| 1 | |||||