how to combine 2 excel file which each has own set of data and gra
Yang
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
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
On 6/8/08 8:49 AM, in article
81F609CF-2469-46C8...@microsoft.com, "Yang"
Bob Greenblatt
81F609CF-2469-46C8...@microsoft.com, "Yang"
<Ya...@discussions.microsoft.com> wrote:
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.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
golf...@gmail.com
>
> <Y...@discussions.microsoft.com> wrote:
> > 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
>
> 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.
>
> --
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom
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.