Thread
:
What is the quickest method to insert & name multiple worksheets .
View Single Post
#
4
January 20th, 2005, 08:13 PM
clyonesse
external usenet poster
Posts: n/a
Jimbola -
A VERY generous offer on your part ... if your calendar permits, I would
like to take you up on your offer ... but will understand if this is not
possible. Would only need 2 spreadsheets with daily worksheets in each: One
each for Feb & Mar
Example: Feb-1 / Feb-2 / Feb-3 / and so on ...
My e-mail address is:
Even if you can't provide the spreadsheets, your response is greatly
appreciated !
- clyonesse
"Jimbola" wrote:
There are really only 3 ways to do this
1_ Manually-but as you say too time consuming
2_Use John Walkenbac PUP add-in but this cost about £36 ($50)
3_Create a macro.
I have PUP so can do 2 for you if you give e-mail address to send the
workbook to (1 time offer)
"clyonesse" wrote:
Need to create several spreadsheets ... each containing multiple worksheets
...
Example: Monthly spreadsheets containing a separate worksheet for each day
of that month ... Jan-1; Jan-2; Jan-3, etc.
Aside from inserting/copying on an individual worksheet basis (too
time-consuming), is there any way to create & name multiple worksheets within
the same spreadsheet ?
clyonesse