[mso] Re: Excel Newbie Q<g>
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 31 Oct 2003 20:13:24 -0600
Yeah...I tried the template thing...but apparently that's not what he
wants?????
Then again, I don't think he knows WHAT he wants!<eg>
Dian D. Chapman
Technical Consultant,
Microsoft MVP & Instructor
Free Tutorials: www.mousetrax.com/techtrax
Free Word Tips & Tricks eBook: www.mousetrax.com/books.html
Learn VBA the easy way, thru video! www.mousetrax.com/techcourses.html
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Greg Chapman
Sent: Friday, October 31, 2003 6:07 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel Newbie Q<g>
One of the things you'll be heading for is to create an XLT file, the
equivalent of a Word template. You can simply take a blank copy of your
current spreadsheet, rename it with the XLT extension and Excel will begin
to honor it as the base design for any new sheet you create with it.
Then you can create a base sheet from that template, copy what you've
already done to it and set a reference to the base XLT. We can add code
later that will add a new worksheet for the current week.
Greg
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Dian Chapman
Sent: Friday, October 31, 2003 4:12 PM
To: Mso
Subject: [mso] Excel Newbie Q<g>
Hi folks...
Okay, here's Dian, entering the group as a subscriber and Excel newbie to
ask Qs!<g>
So...we have this Excel timesheet from HELL that the boss forces us to fill
out each week. We have to look all our time and set all the client
billing...blah, blah, blah.
But it appears that, rather than making a master template of sorts
(remember, my only frame of reference here is Word!). So to use each
week...they just take the old one, erase the info and enter the new info.
ARRGGHHH! Not me! I'm gonna learn how to do this RIGHT...if you Excel folks
will help me!
But for today, I don't have time to worry about the template issue, I'll ask
that one later. For now, I'd like to at least take last weeks worksheet (is
that right???) and add a new copy of it into the workbook (is that the right
term????). The boss wants to have ONE book of all my timesheet so tabs at
the bottom would show the dates for each week. What I've been doing to date
is creating a whole new xls each week from a blank one I created.
There is some listboxes and a little bit of formula stuff in here (which
I've REALLY got to improve, quick<g>)...so I'm shy about what I can do with
this.
Appreciate any help adding one sheet into a previous book.
--------------------------------------------
Dian D. Chapman
US Microdyne
2275 Half Day Road
Suite 350
Bannockburn, IL 60015
E-Mail: DChapman@xxxxxxxxxxxxxxx
Toll-Free: 800-828-3859
Phone: 847-244-4800
Fax: 847-244-4801
-------------------------------------------
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
