[mso] Re: Excel combine workbooks directions needed

Hi,
you can open a new workbook, save it, and then open, in turn, each of the 
workbooks you have, select the worksheet you want and export it to the new 
workbook (Edit-->Move or Copy Sheet, then  under "Move Select Sheets" 
select the name of the new workbook). Be sure to check the box "Create a 
Copy" every time to preserve the original workbooks until you're finished.
After the worksheets are all copied to the new workbook, go through the 
sheet tabs and rename them as you wish.
If the numbers of worksheets is very great, you might try recording a macro 
to do it.
Wilson

At 08:35 16/10/2004, L Wessels wrote:
>Problem is:  I'm working in Excel 2000 with spreadsheets that someone else 
>setup and did entries for.  It's for an alumni association and they set up 
>each year in a different file.  It's really used as a database.  All have 
>same fields.  Each file has only one worksheet and most worksheets have 
>the same name as the file, ie 1924.  What is the easiest way to merge all 
>these files into one spreadsheet file with, perhaps, a different worksheet 
>for each year? If someone can guide me, I'd really, really appreciate the 
>help.
>
>Thanks!!
>
>lwessels


*************************************************************
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).
http://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: