Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto duplicating a sheet
That can be a bit confusing but I'll try to explain. I have been naming the
sheets to represent the drivers work week which starts on Thurs and ends the following Wed. So for example Mar 3 - Mar 9 would be one sheet then Mar 10 - Mar 16 would be the next and so on. Our weeks are based on the school calendar week starting with the first day of school Sep 2 - Sep 8. Hope this makes sence. "JulieD" wrote: Hi yes, this can be done via VBA, however, if you'ld like to let us know how you would like your 42 sheets named we can incorporate this in the code. Cheers JulieD "dvonj" wrote: I have just completed working on a sheet and now need to make copies of it. I know I can right click on the sheet tab and select copy however I need 42 sheets. Is there a way to program XL to create 42 copies of the worksheet. I am not real familuar with VBE but with help can work through it. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Copy/autofill Text from sheet to sheet if meets criteria | Excel Discussion (Misc queries) | |||
Duplicating Worksheet to 20 sheet workbook | Excel Discussion (Misc queries) | |||
Auto duplicating a sheet | Excel Programming | |||
Auto Duplicating Worksheets and Insterting Data from Different Worksheet | Excel Programming | |||
Duplicating data from sheet 1 to 2,3,4 etc | Excel Programming |