how to combine 2 excel file which each has own set of data and gra

[Yang]

Can anyone advice how do I do the below?
i have 1.xls and 2.xls
each xls has own set of data and graph
i would like merge them into one or merge 2.xls to 1.xls

 

[CyberTaz]

One option:

Open both workbooks with the one you don't want to keep as your active
window. Select all sheets in the workbook, then right-click one of the tabs
& choose Move or Copy...

In the dialog that appears open the top list & select the other workbook (as
well as specific position if you wish), then click OK.

BTW - it appears that you got here through the MS Discussions site & that
you may well be using a PC - this is the Mac Excel newsgroup For any
further assistance with the Windows version of a MS program use the
following link - and always specify which version of the program as it can
often make a difference even within the same OS:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[golfshoe]

You can easily make a workbook with 2 work sheets. If the files have the
same data format, simply copy one set of data to the bottom of the other.
The move the chart to that worksheet and insure that the series formula got
properly updated.  If this is not what you mean by "merge" please explain in
more detail about the data formats and what you'd like as a result.

The only Mac OS X program that can combine multiple .xls, .txt,
or .csv is Excel File Merger. We typically process thousands of
separate customer files and most times we have to manually merge these
files into one master file by hand - until now. If you save your
Excel files as .csv, we can do a merge of about 13,000 files in about
2-3 seconds. I kid you not. Download the software here:
http://essexredevelopment.com/mac/excelmerger.html I believe there is
demo version to try.