+ Reply to Thread
Results 1 to 2 of 2

How to copy a sheet from one workbook as a sheet onto multiple workbooks

  1. #1
    Registered User
    Join Date
    07-25-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    1

    Question How to copy a sheet from one workbook as a sheet onto multiple workbooks

    Hi All,

    I need some help copying and overwriting a tab from A workbook to MANY workbooks. For example, I have workbook 'Products Master' and in it I have a tab called 'Instructions'.

    I want to copy the tab/sheet 'Instructions' onto the following workbooks and replace its existing 'Instructions' tab with the new one:

    - 'Product 1'
    - 'Product 2'
    - 'Product 3'
    - 'Product 4'
    - 'Product 5'
    - 'Product 6'

    I have 150+ products workbooks but lets use 6 as an example.

    is there a quicker way to do this using VBA or Macros rather than opening each and every workbook and copying and pasting so many times?

    Thanks Guys.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to copy a sheet from one workbook as a sheet onto multiple workbooks

    This may take awhile, but maybe:

    Please Login or Register  to view this content.
    Note: Change .xls in code to .xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vba to copy from multiple workbooks to a summary sheet in another workbook.
    By lisadykstra in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-22-2014, 03:36 PM
  2. VBA to extract sheet in multiple closed workbooks to a sing sheet on new workbook (HELP!)
    By The1theycallp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-12-2014, 08:19 AM
  3. [SOLVED] Consolidate Data from 1 Range on 1 Sheet in Multiple Workbooks to Master Workbook Sheet
    By Jennasis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2013, 06:11 AM
  4. Copy Sheet from one Workbook to Multiple Closed Workbooks
    By sflexi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2013, 10:01 AM
  5. [SOLVED] VBA: Copy First Sheet of a List of Workbooks to New Workbook
    By DHartwig35805 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-12-2012, 06:05 AM

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