automate the tab naming

  • Thread starter Thread starter philtyler
  • Start date Start date
P

philtyler

I would like to create a workbook with 52 sheets, 1 for each day of th
year.
I'd rather not create and name 365 tabs by hand.

Creating the tabs isn't the issue, I can set that option from th
toolbar, but the naming, 1 per day of the year, could be a pain in th
but maybe someone can help out
 
You could easily do that by putting the sheet names in let's say A1:A365 and
run a macro however I would strongly recommend that you avoid this, from a
spreadsheet design point of view it is not good. This sounds like audit hell
and if you use any formulas it could also make it very slow and almost
impossible to use.
If you are just filling each sheet with data you might want to consider a
data base program


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating automated timesheets 2
Excel Is this possible?? 3
Automating TAB names in calculations 3
Save Worksheet To Master Workbook 5
months on separate tabs 1
Summary sheet from tab names 3
Formatting font and color of worksheet tabs 2
Count If 9

Back
Top