[mso] Re: Excel Newbie Q<g>
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 31 Oct 2003 21:10:48 -0600
>BTW I like the new format "signature".
Me? HA...that's a forced sigLine from the office!
>There will probably be a maximum number of clients a week to bill...
Thanks for the info. I may do a year's worth...but I also will need to add
some of my own VBA into this to automate the process somewhat. Geez...now I
have to learn the Excel objModel, too!<g>
The client issue isn't really a big deal cos' there's yet another
spreadsheet for that...billing.<sigh> This is to pay me for my own time. And
there aren't really too many entries. Maybe 3-5 a day for 7 days. I just
have to set subject for each project number I work on in a day...what
client...details, start/end time, any mileage, etc. It's just all smashed up
together and pretty funky...a little fine tuning could make it 100% better.
Just have to learn how HE did it...so I can do it better.
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 Green
Sent: Friday, October 31, 2003 5:56 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel Newbie Q<g>
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
*************************************************************
*************************************************************
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:
