+ Reply to Thread
Results 1 to 2 of 2

Problem copying worksheet to another workbook

  1. #1
    Registered User
    Join Date
    01-01-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Problem copying worksheet to another workbook

    I want to copy a worksheet in workbook A to workbook B. Both workbooks are in the same folder in my documents. I am using Windows 7. I open both workbooks and try to copy by clicking on the worksheet tab but the workbook B does not show up in the "copy to" box. I have also tried copying and pasting which does work except that the formula in the different cells do not copy over. Help would be appreciated.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Problem copying worksheet to another workbook

    Hello,

    do you have the workbooks open in the same instance of Excel?

    Close Excel. Open the first workbook. Then use the File > Open command to open the second workbook. Now you should see that workbook in the drop-down of the sheet copy dialog.

    cheers,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1