+ Reply to Thread
Results 1 to 2 of 2

Excel: Merging specific worksheets from different workbooks into a master file

  1. #1
    Registered User
    Join Date
    11-24-2021
    Location
    London
    MS-Off Ver
    2021
    Posts
    1

    Exclamation Excel: Merging specific worksheets from different workbooks into a master file

    Hi all,

    I'm just starting with VBA, so I would like some help with this task at hand.

    I have four Excel files named "C Tier 4", "L Tier 4", "S Tier 4", and "O Tier 4". Within each of these workbooks, there's a tab called "Data" containing information that I need to combine and extract to a master file (another file). Unfortunately, one of the columns in "O Tier 4" is incorrectly placed, so I need to make sure the workbook columns match the name of the master file columns. Also, since I already have the headers on the master file, I would have to combine the data starting on cell A4.

    How would I go about creating a button with VBA code to allow me to do that?

    Thanks in advance,

    XD

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    54,512

    Re: Excel: Merging specific worksheets from different workbooks into a master file

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new here I will do it for you this time: https://www.mrexcel.com/board/thread...-file.1188575/ and https://www.msofficeforums.com/excel...ooks-into.html)
    Last edited by AliGW; 11-25-2021 at 03:45 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. Copying specific cells from different closed workbooks to a Master Excel file
    By kennad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2015, 09:34 AM
  2. merging specific worksheets from multiple workbooks into one new workbook
    By cwchan220 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-14-2014, 10:26 AM
  3. Merging excel workbooks into a master workbook with seperate sheet for each file
    By heshfer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2014, 01:31 PM
  4. [SOLVED] Merging multiple closed worksheets into a master file
    By ghoststark21 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2013, 05:22 PM
  5. Pasting data from MANY workbooks into specific worksheets of a master workbook
    By beemoney19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2012, 11:30 PM
  6. Merging multiple workbooks (with multiple worksheets) in to one master sheet
    By inkandpaint in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2012, 09:46 AM
  7. Merging specific Worksheets into one Master Worksheet
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2009, 07:34 PM

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