+ Reply to Thread
Results 1 to 4 of 4

VBA/Macro to combine sheets from different workbooks

  1. #1
    Registered User
    Join Date
    12-09-2015
    Location
    Fort Worth, TX USA
    MS-Off Ver
    2013
    Posts
    4

    VBA/Macro to combine sheets from different workbooks

    I have multiple workbooks in a common folder. I need to combine specific worksheets from each (score sheet) them into a master sheet with results. I.E. the header on the master sheet should only appear once. Would be great if automatic, but a button will work. Thanks for our help
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,612

    Re: VBA/Macro to combine sheets from different workbooks

    This link may help.
    Consolidate data in multiple worksheets
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    12-09-2015
    Location
    Fort Worth, TX USA
    MS-Off Ver
    2013
    Posts
    4
    Thanks
    The sheets are in different workbooks, though

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,612

    Re: VBA/Macro to combine sheets from different workbooks

    This is from the first paragraph in the link...

    To summarize and report results from separate worksheets, you can consolidate data from each sheet into a master worksheet. The sheets can be in the same workbook as the master worksheet, or in other workbooks. When you consolidate data, you assemble data so that you can more easily update and aggregate as necessary.

+ 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. Replies: 3
    Last Post: 02-06-2018, 12:53 PM
  2. Vba/macro to combine multiple workbooks with multiple sheets into one workbook
    By ReshayM in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-03-2015, 01:00 PM
  3. Replies: 0
    Last Post: 02-13-2015, 04:26 AM
  4. Combine several workbooks containing data in multiple sheets into a master Workbook
    By sunrize9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2014, 09:10 PM
  5. 1. Promt User to Point to Location of Workbooks. 2. Combine Sheets
    By jcranst in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2012, 01:51 PM
  6. Replies: 5
    Last Post: 04-21-2012, 02:07 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