Creating a monthly sheet

**daviddoria** · 07-10-2009, 07:56 AM

I've written a script to produce a new sheet every month with just a few small modifications (e.g. the title would change from "January" to "February"). Currently the script completely generates the sheet from scratch - filling in text and formulas in all of the cells

Please Login or Register  to view this content.

It seems like it would make more sense to create the sheet using then normal excel GUI, copy the sheet, and use the script only to make the small modifications. However, it seems pretty goofy to have a "blank" sheet visible to the user. Is there a way to "hide" the blank sheet so no one knows it's there (and also doesn't mess with it). Or is there a better way to do this "I need a new sheet every month" type of operation? It seems like that should be a pretty common thing to want to do.

Thanks,

Dave

**sweep** · 07-10-2009, 08:39 AM

Would something along the lines of this work for you?

Please Login or Register  to view this content.

**daviddoria** · 07-10-2009, 08:44 AM

Sure - that is what I was talking about doing, thanks. But is this a "standard practice" in the excel world?

**royUK** · 07-10-2009, 08:47 AM

It depends what the "monthly" sheet is to be used for, but if it is data input thn i would have one main data sheet with a column for dates then use AutoFilter or PivotTables to review the data

**daviddoria** · 07-10-2009, 09:08 AM

I have attached the sheet that I need to fill out each month. The script to generate a new month's sheet automatically runs when the file is opened on a day whose month does not match the latest sheet's month. Does doing it like this make sense?