+ Reply to Thread
Results 1 to 2 of 2

Copy Sheet from one Workbook to Multiple Closed Workbooks

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    Nebraska
    MS-Off Ver
    Excel 2010
    Posts
    1

    Copy Sheet from one Workbook to Multiple Closed Workbooks

    Hello!

    I am very new to Macros and was hoping that y'all could help me out.

    I am looking to copy/move a tab called "Summary" in a file called "Base" to 303 other files that are in the same file in my directory, but all have different names.

    The catch with this is that the Summary tab is formulated. It calculates the cell from data in other tabs in the same workbook. I need the macro to open the file, move/copy the Summary tab, break the link with the Base file so that it's looking at the correct data when calculating things, save the file, and repeat with the rest of the files.

    I would appreciate any help you can give me!

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,681

    Re: Copy Sheet from one Workbook to Multiple Closed Workbooks

    break the link with the Base file so that it's looking at the correct data when calculating things
    And how would one know what links to break and how and where to find the correct data?

    Alf

+ Reply to Thread

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