make copies of worksheet for each day of month
 

I need to make a copy of a template worksheet for each day of the month, not
sheets in the workbook, but separate excel files in a folder...11-1-08
through 11-30-08 in folder called Timesheets. Have been just creating first
day of the month worksheet, saving, then renaming it the next day of the
month and saving it again and so on...any suggestions on a quicker way?

Thanks

make copies of worksheet for each day of month
 

hi
I did this back in the 80's. real dumb. you don't need to put all of your
records in individual files. some day you will need to review all your
records and you will be either opening one file after another or posting
here wanting a macro to do that for you plus summerize for you or do some
kind of analysis.
instead, you need to stick all of your records in a database. since access
is better suited for this, i would recomend that you export to access. but if
you keep it to a single topic, excel might do. you may need some tricky
coding but that is far better that scattering your record throught
individuals files. believe me. been there. done that. will not do it again.

my thoughts
regard
FSt1


"Rhett C" wrote:

I need to make a copy of a template worksheet for each day of the month, not
sheets in the workbook, but separate excel files in a folder...11-1-08
through 11-30-08 in folder called Timesheets. Have been just creating first
day of the month worksheet, saving, then renaming it the next day of the
month and saving it again and so on...any suggestions on a quicker way?

Thanks