Results 1 to 9 of 9

have multiple tables on separate sheets, how to combine

Threaded View

  1. #1
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    have multiple tables on separate sheets, how to combine

    i have this routine that is not working on tables. How can I copy tables from multiple sheets and have them combine into one?

    this is not working:

    With Sheets("Purchase Requisitions")
            .Range("A1").CurrentRegion.Copy
            If Sheets("Summary").Range("A1") = "" Then
                Sheets("Summary").Range("A1").PasteSpecial xlPasteValues
            Else
                Sheets("Summary").Range("A" & Rows.Count).End(3)(2).PasteSpecial xlPasteValues
            End If
        End With
    the problem is that this copies only the text and not the structure of the table (like banded rows, header row with drop downs, etc)

    so i did some research and found this link

    i expected this snippet of code to work, but i get an error that the subscript is out of range. i went to the "Purchase Requisitions" sheet and verified the name of the table so why isn't this working"

    ActiveSheet.ListObjects("Table 19").Range.Select
    Sheets("Summary").Range("A" & Rows.Count).End(3)(2).PasteSpecial xlPasteValues
    the sheets that have the tables are: "Purchase Requsitions", "Outstanding POs", "Open POs", "Closed POs" and "Archived POs". All the tables go to the "Summary" sheet.
    Last edited by dmcgov; 07-25-2017 at 08:49 AM. Reason: added sheets

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need to combine separate sheets into a log - Consolidation
    By taylorsm in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-10-2017, 10:54 AM
  2. Several sheets, several tables, combine and lookup
    By NoSleepForMe in forum Excel General
    Replies: 0
    Last Post: 02-06-2017, 04:26 AM
  3. Combine Vlookup different tables (sheets)
    By sab128 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-08-2016, 07:04 AM
  4. Replies: 1
    Last Post: 02-26-2016, 12:05 PM
  5. [SOLVED] Macro needed to Concatenate data in 2 separate tables of 2 separate sheets
    By 823 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-08-2015, 02:02 PM
  6. How do I combine data tom 2 separate sheets
    By njbula in forum Excel General
    Replies: 1
    Last Post: 01-09-2015, 01:26 AM
  7. Pivot Tables - need to do separate pivot tables for multiple sheets in same format
    By tconnell1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 07:04 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