[mso] Re: Excel Newbie Q<g>
- From: "Green" <1z@xxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sat, 1 Nov 2003 00:56:09 +0100
Hi Dian,
BTW I like the new format "signature".
Would putting week numbers on the tabs save a bit of space down there
on the left?
I think I'd also set up a whole years full of worksheets and use that
as a copy/template with at least one summary sheet.
That gets around copying a worksheet every week... It's already there.
There will probably be a maximum number of clients a week to bill...
200? :-) So the sheet can have fixed ranges "for now". ow many lines
does the original worksheet have? Use the same or more.
In Exel 2000...
Open the workbook
In the workbook with the blank week, first save as a new 'un so you
don't you know what.
Right click the tab for the sheet and click "Move or Copy".
Tick the "create a copy" box.
That will create a copy of the selected worksheet in the current
workbook.
It's a pain but if you do this 50 odd times then you have a whole
year... Then you have to rename the sheets to what you want. Right
click the tab and click rename.
This is the very simplest way... I think. but it's quite labour
intensive to set up.
Eventually you end up with 52 or so sheets in the workbook.
This should partly satisfy your boss. He'll have all 50+ weeks laid
out for him.
If you enter sum formulas at the bottom of the fixed ranges then you
can copy and paste each weeks data into your new single workbook and
you should get the same summed totals as you did in the seperate
workbooks. I would check that as well just to make sure.
Regards
Lisa
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
> Behalf Of Dian Chapman
> Sent: 31 October 2003 23:12
> 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
*************************************************************
Other related posts:
