Macro to Create Dated Worksheets

[Noah.Pielert]

Ok, I want to do a couple things.

I have a daily report that needs to be filled out, and it is the same for each day.

I want to create a macro that will create 365 dated tabs, and at the same time, I want each of those dated tabs to copy the original template.

So far I have found a macro that will create dated tabs in the format of mm-dd-yyyy, but I can't figure out how to copy the data/formats from my original template.

Also, I have a date column in the template, and I want the date column to pull the date from the dated tab name.

Can anyone help?!?!?!

[shg]

Welcome to the forum, Noah.

If you're going to do any analysis of the data that crosses day boundaries, you should have all data on a single tab with a column for date. That's how Excel is designed to work.

[JBeaucaire]

Sounds like you really just need to copy your template sheet.

Please Login or Register  to view this content.

The make further changes to the new sheet as needed...


Since your tabs ARE dates, you really just want to display the tab name in the date column on those new sheets, yes? You can do that with this formula:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

[Noah.Pielert]

Thanks for the responses guys. I'm not actually analyzing data really, its a daily activity report for my friend that works at the Ritz Carlton. Here was a macro that I found that does what I want, except 1: It doesn't Create the Sheets in the same workbook, it creates a new one and 2: I had previously tried the mid formula above to reference the sheet name in the cell, but I got a #VALUE error.

Please Login or Register  to view this content.

This one actually only created tabs by month, but that is fine. My friend just wants do create each month at a time without a whole lot of work because the employees using the spreadsheet aren't good with excel, so he didn't want to have them have to copy the sheets each day and set them up.

I attached a copy of the sheet that I want to duplicate

[JBeaucaire]

Here's a slight rewrite of this... it simply asks for the starting date and how many sheets you want, then it creates them in the active workbook:

Please Login or Register  to view this content.

[Noah.Pielert]

Thanks JB. I have another question. Would it be possible to copy everything from a current sheet that I already have (Formats, data, etc.) to each of the new worksheets that the macro you provided creates?

[JBeaucaire]

You asked that already and I answered in post #3. That's the code for that, replace the Worksheets.Add from this macro with the construct from post #3 and edit it for your needs.


By the way, the formula I gave you in that same post only displays the proper answer AFTER you save the workbook at least once.

[Noah.Pielert]

Got it! I'm new to this so I appreciate the help JB,

Thanks

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.