[mso] Re: Excel combine workbooks

Hi,
I'm sending my answer to the MSO list, as the question was originally put 
there. Answers below, inside message body.
Wilson

At 17:24 26/10/2004, L Wessels wrote:
>Thanks Wilson.  I think this is what I did, but I used drag & drop.  I 
>posted a new question with some concerns.  It says:
>
>Hello again,
>
>I combined many workbooks to one workbook by opening the "mergedall" workbook
>and each one of the ones I wanted merged, one at a time, and drug (dragged?)

dragged <G>

>the worksheet to the "mergedall" workbook.  Each workbook that I merged had
>only one worksheet.
>Is there, will there be, a problem because I did it that way?

AFAIK, no.

>Can I safely delete the workbooks that I merged once they are all merged?
>Are they somehow linked to the new "mergedall" workbook?

I think not; but just to make sure, open the "mergedall" workbook and go to 
the "Edit" menu. If the workbook is linked to any other the "links" option 
will be live, if not, it will be grayed out.

>Now my one workbook is huge, about 5000 kb.
>
>Thanks for any guidance, here.
>
>Date: Sat, 16 Oct 2004 09:06:37 -0300
>From: Wilson Baptista Junior 
><<http://us.f605.mail.yahoo.com/ym/Compose?To=wilson@xxxxxxxxxx&YY=39516&order=down&sort=date&pos=0&view=a&head=b>wilson@xxxxxxxxxx>
>Subject: [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!!


*************************************************************
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: