Cool! Thanks. Yeah, I have to get the hang of this copy stuff in Excel cos' it seems to work a little funkier than I'm used to in all other apps. But I plan to study up and learn this stuff...if for no other reason than to do it BETTER than "Mr. Excel."<g> (He's made the mistake of harping on my Word stuff and CONTINUALLY telling me EVERYTHING should be done in Excel!<smirk>) The last person who challenged me was my boss (of many years...when WE first met..about 11 yrs ago). HA...he told me I should learn to read manuals!<lol> And you can see where THAT lead! 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 Linda F. Johnson Sent: Friday, October 31, 2003 4:52 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Excel Newbie Q<g> Yay, Dian...finally I get to help YOU LOL Ok....open the book with the sheet in it that you want to copy into the other book...then also open the other book....so you have them both open in Excel at the same time. Then RIGHT click on the sheet tab (at the bottom) of the sheet you want to copy into the other book and choose "move or copy"....then a little box comes up and use the dropdown box at the top to select the other workbook....and, if you want to MOVE it, just click OK...but if you want to COPY it, put a check in the box that says "create a copy" You can also just highlight all the cells in one workbook and copy them and paste them into another workbook, but then you lose stuff like your sheet tab names, etc. Linda F. Johnson, M.A., MOS Linda's Computer Stop http://personal-computer-tutor.com Free e-Books, Newsletter, and tutorials -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Dian Chapman Sent: Friday, October 31, 2003 5: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 ************************************************************* 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 *************************************************************