+ Reply to Thread
Results 1 to 2 of 2

Macro to combine multiple worksheets, but there's a hitch

  1. #1
    Registered User
    Join Date
    05-20-2019
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2016
    Posts
    1

    Lightbulb Macro to combine multiple worksheets, but there's a hitch

    I have nine worksheets that I need to consolidate into one master worksheet. I'd like for the master to automatically update when the individual sheets are updated.

    Here's additional detail:

    * Each worksheet has the same headers across 20 columns.
    * Cells are text only, no numbers.
    * Row length varies across all worksheets.
    * There are some blank cells.
    * There is a worksheet in the file that holds data for drop-downs in the worksheets, so I need to exclude this one from the master.

    I've gone round and round trying to figure this out! Any help would be greatly appreciated!

    Thank you.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,694

    Re: Macro to combine multiple worksheets, but there's a hitch

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. Need Macro to combine multiple worksheets into one
    By A.Patel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2013, 09:26 PM
  2. Required Macro for combine multiple workbooks which contains multiple worksheets
    By DHANASEKARAN in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2013, 03:20 PM
  3. Macro to combine multiple worksheets
    By joyhampton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2013, 02:30 PM
  4. [SOLVED] Macro to combine multiple cells from multiple worksheets into one worksheet
    By sharpmarc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-20-2013, 02:42 PM
  5. Macro to combine multiple worksheets into a Master file
    By hazte22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2012, 04:28 AM
  6. [SOLVED] Using Combine macro to combine multiple worksheets - need to modify to paste formulas
    By DLSmith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 09:07 AM
  7. A macro to combine multiple worksheets
    By alloutdoors681 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-04-2011, 07:48 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