+ Reply to Thread
Results 1 to 3 of 3

Combine multiple sheets into one

Hybrid View

bjohnsonac Combine multiple sheets into... 12-19-2019, 01:16 PM
JLGWhiz Re: Combine multiple sheets... 12-19-2019, 02:00 PM
bjohnsonac Re: Combine multiple sheets... 01-06-2020, 04:02 PM
  1. #1
    Registered User
    Join Date
    09-26-2008
    Location
    North Myrtle Beach
    MS-Off Ver
    365 Business
    Posts
    82

    Combine multiple sheets into one

    Been quite a while since I have created macros from scratch, so I need some help getting my brain back into it. I have a workbook that has multiple tabs, each with a different number of rows that will be occupied with data each month. I need to write a macro that will copy the rows from each sheet that has info in column A, into the new sheet I have created at the beginning of the Workbook. I already wrote the simple macro to create the new sheet titled "Summary", now need help getting the one together to search each sheet for the data and copy to the next available row in the "Summary Sheet".
    Thanks for helping me get back into the swing of things!
    Beth

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Combine multiple sheets into one

    Based on what I could glean from the OP.

    Sub t()
    Dim sh As Worksheet
        For Each sh In ThisWorkbook.Sheets
            If sh.Name <> Sheets(1).Name Then
                sh.UsedRange.AutoFilter 1, "<>"
                sh.UsedRange.Offset(1).SpecialCells(xlCellTypeVisible).Copy
                Sheets(1).Cells(Rows.Count, 1).End(xlUp)(2).PasteSpecial xlPasteValues
            End If
            sh.AutoFilterMode = False
        Next
    End Sub
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  3. #3
    Registered User
    Join Date
    09-26-2008
    Location
    North Myrtle Beach
    MS-Off Ver
    365 Business
    Posts
    82

    Re: Combine multiple sheets into one

    Perfect
    Thanks!

+ 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. Combine multiple sheets
    By splendid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-20-2019, 01:25 PM
  2. Macro to combine multiple sheets from multiple workbooks
    By snikrs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2018, 02:08 PM
  3. 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
  4. Excel 2007 - Combine Multiple Workbooks into one Workbook Multiple Sheets
    By mab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2014, 02:48 PM
  5. Combine multiple sheets of multiple workbooks in one sheet
    By Djibril69 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2013, 05:18 PM
  6. [SOLVED] align or combine multiple columns from multiple sheets into one sheet in sequence
    By calif in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2013, 11:49 AM
  7. Combine multiple sheets
    By sanam in forum Excel General
    Replies: 5
    Last Post: 03-03-2009, 01:12 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