+ Reply to Thread
Results 1 to 2 of 2

VBA Macro - Consolidating Tabs and Updating Column

  1. #1
    Registered User
    Join Date
    07-21-2017
    Location
    NY
    MS-Off Ver
    16.0
    Posts
    25

    VBA Macro - Consolidating Tabs and Updating Column

    Hi Everyone,

    I am working on a project for fun and the below is what I am trying to achieve:

    - Copy all data over into a "Master" worksheet from tabs with "ABC" in the worksheet name, i.e. copy from "ABC - 1", "ABC - 2", "ABC - 3", but not "XYZ - 1" or anything without "ABC".
    - Only copy over the header once, as each ABC worksheet has the same header
    - Rename the values in the name column in the "Master" worksheet based on the "Name Key" tab (i.e. if name is Michael, change to Mike). Some sort of lookup?
    - Rename the name for Juliana to either "Jules (1)" or "Jules (2)", based on the value in the date column. If date is before 10/1/2020, then change to Jules (1). If date is on or after 10/1/2020, then change to Jules (2). Just for this name though, no-one else.

    I have managed to achieve the first and second bullets (as seen in the VBA and output in "Master" tab) through the following code:

    Please Login or Register  to view this content.
    If anyone can figure out or attach the VBA code for the rest, that would be really helpful! I have tried multiple times and browsed sites, but have not been successful.

    I have attached an example of what the "Master" sheet would look like (this can be seen in the highlighted tab - "Intended Output - Master"), including a refresh button.

    Thank you!
    Attached Files Attached Files
    Last edited by jos283; 04-30-2020 at 07:46 PM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA Macro - Consolidating Tabs and Updating Column

    Duplicate thread

    https://www.excelforum.com/excel-pro...orksheets.html

+ 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. Consolidating items from multiple tabs to one tab
    By renix in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-05-2016, 04:00 PM
  2. Replies: 1
    Last Post: 11-25-2015, 06:15 AM
  3. [SOLVED] Consolidating Data From Multiple Tabs / Worksheets By Column Name
    By connectuk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-07-2015, 07:19 AM
  4. Consolidating Multiple Tabs of Data
    By Beach Bum in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2013, 06:09 PM
  5. Consolidating Tabs and tab names
    By athard in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-03-2011, 06:50 PM
  6. Consolidating tabs
    By Bern2007 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2009, 06:08 PM
  7. Consolidating Workbook Sheets (i.e., Tabs)
    By Bob in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-31-2006, 12:58 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