Results 1 to 2 of 2

Thread: Merging workbooks in excel 2007

  1. #1
    Join Date
    Jul 2010
    Posts
    1

    Merging workbooks in excel 2007

    I need to merge two sets of data so that I can compare data from two years. The data are: a list of school districts, the number of class days scheduled, and the number of days canceled.

    There may be some school districts listed in one worksbook but not the other.

    Thank you.
    Last edited by rico123; 26-07-2010 at 08:25 AM.

  2. #2
    Join Date
    Dec 2007
    Posts
    2,288

    Re: Merging workbooks in excel 2007

    1.Make sure the copies of the workbook that you want to merge are all stored in the same folder. To do this, you must give each copy a different name.

    2.Open the copy into which you want to merge changes.

    3.On the Tools menu, click Compare and Merge Workbooks.

    4.If prompted, save the workbook.

    5.In the Select Files to Merge into Current Workbook dialog box, click a copy that has changes to be merged, and then click OK.

    To merge more than one copy at the same time, hold down CTRL or SHIFT and click the file names, and then click OK.

Similar Threads

  1. Replies: 2
    Last Post: 02-02-2012, 04:46 PM
  2. Excel 2007 compatibility mode and Offline files and shared workbooks
    By shivendra in forum Windows Vista Network
    Replies: 2
    Last Post: 16-11-2011, 10:01 PM
  3. Snap feature from windows 7 with excel workbooks
    By laplapye in forum Windows Software
    Replies: 4
    Last Post: 28-11-2010, 01:49 AM
  4. Replies: 5
    Last Post: 25-03-2010, 06:23 AM
  5. How to minimize Metadata in Microsoft Excel Workbooks?
    By Orton in forum Windows Software
    Replies: 5
    Last Post: 10-03-2010, 05:57 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,751,694,658.15842 seconds with 16 queries