Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying a form
I have a form created in Excel to be used as a daily checklist
How can I reproduce 364 times easily to produce one book, and is there a way I can create a rolling header which would attach each date to the top of each page Hope this makes sense Thanks for any help -- Jean |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying a form
You would need a simple macro. Can you answer some simple questiopns
1) Where is your data located and what date do you want to start at? Some people want Jan 1 an other people use a different phisical year 2) Do you want the macro to work for more than one year 3) What is the tab name of the sheet you want copied. Usually a "Master" or or a sheet with a date. If you workbook has only one sheet then the first tab can be used. 4) How do you want to name each tab? It can be the date but specify the format of the date you would prefer. Make it clear if it is the day or month 1st 3/1/09 can be March 1st or Jan 3rd. "jeanmhealy" wrote: I have a form created in Excel to be used as a daily checklist How can I reproduce 364 times easily to produce one book, and is there a way I can create a rolling header which would attach each date to the top of each page Hope this makes sense Thanks for any help -- Jean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Form cells (WS1) to Database (WS2) | Excel Discussion (Misc queries) | |||
Help with copying and e-mailing excel form | Excel Discussion (Misc queries) | |||
Help-Copying Word Form into Excel | Excel Discussion (Misc queries) | |||
Copying data form website | Excel Discussion (Misc queries) | |||
copying chart Excel into a vb form | Charts and Charting in Excel |