Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two files with multiple worksheets in each that I would like to combine into one file. I want the formulas to remain but without the association to the old file.

share|improve this question

migrated from stackoverflow.com Oct 12 '09 at 16:55

This question came from our site for professional and enthusiast programmers.

    
Do you mean to do it by hand or to make a program to do it ? if a program in which language .. I think your question is incomplete. – Jean Aug 26 '09 at 15:19
    
May not matter completely, but version of excel might help. – Rob Aug 26 '09 at 15:31
  1. Select the worksheet or worksheets you want to copy (use ctrl-click to select multiple tabs)
  2. Right click one of the selected tabs
  3. Select Move or Copy...
  4. Select the destination workbook and the location within the workbook
  5. Check "Create a copy" if you want to copy rather than move the worksheet(s)
  6. Click OK.
share|improve this answer

You must log in to answer this question.