Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
    
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
add comment

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

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

1 Answer

  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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.