Results 1 to 12 of 12

Copy sheet from one workbook to another

Threaded View

Jakes Copy sheet from one workbook... 02-29-2012, 10:18 AM
arlu1201 Re: Copy sheet from one... 02-29-2012, 10:56 AM
Jakes Re: Copy sheet from one... 02-29-2012, 02:15 PM
arlu1201 Re: Copy sheet from one... 02-29-2012, 02:35 PM
Jakes Re: Copy sheet from one... 02-29-2012, 02:40 PM
arlu1201 Re: Copy sheet from one... 03-01-2012, 03:22 AM
Jakes Re: Copy sheet from one... 03-01-2012, 03:26 AM
Jakes Re: Copy sheet from one... 03-01-2012, 03:19 AM
arlu1201 Re: Copy sheet from one... 03-01-2012, 03:21 AM
Jakes Re: Copy sheet from one... 03-01-2012, 03:25 AM
Jakes Re: Copy sheet from one... 03-01-2012, 03:29 AM
arlu1201 Re: Copy sheet from one... 03-01-2012, 03:47 AM
  1. #1
    Forum Contributor
    Join Date
    03-03-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    123

    Copy sheet from one workbook to another

    Hi there,

    I have made a drawing Issue template, and the first Beta is already released.
    However, I have made a updated version, and I would like to have a easy way to update to the newer version.

    For example, I have Workbook1.1 withs Sheets A, B,C and D
    Now the newer version is Workbook 1.2 With Sheets A,B,C,D and E.

    However, the data is actually only stored in Sheets B,C and D in both the workbooks, with no changes at all.

    I would like to have a macro in Workbook 1.2 that can copy the entire sheets B,C and D from workbook 1.1 to sheets B,C and D in Workbook 1.2

    Note, the workbooks will not necessarily be in the same folder or location.

    Is that possible, and if so, how?

    Best Regards,

    Jakes
    Last edited by Jakes; 02-29-2012 at 10:20 AM.

Thread Information

Users Browsing this Thread

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

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