+ Reply to Thread
Results 1 to 2 of 2

need a macro to create a summary table

  1. #1
    Registered User
    Join Date
    12-29-2015
    Location
    new york, new york
    MS-Off Ver
    2016
    Posts
    1

    need a macro to create a summary table

    Hi All,
    I'm new to macros and I've been working on this for days but can't seem to get it. I have a workbook with 15 tabs/sheets including the summary sheet I've already created. They all have different names (i.e. Apparel, Automotive, Beauty, etc). Each sheet contains the exact same table, with 465 rows (that will continue to grow) and 7 columns. I need for all of that data in each table to be copied over the same table on the existing summary sheet. The summary sheet also contains some other separate tables with formulas, etc that I don't want to be affected.

    I need for the last two sheets on the page to be excluded from the summary. Those are named PASS|R|GY and Sheet2.

    Hope I provided enough info. Thank you for the help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: need a macro to create a summary table

    Submit the workbook with any sensitive information redacted. The pdf is not as useful.
    If you are happy with my response please click the * in the lower left of my post.

+ 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. Replies: 2
    Last Post: 04-16-2013, 06:17 AM
  2. Create summary table automatically
    By mateoc15 in forum Excel General
    Replies: 1
    Last Post: 01-11-2012, 11:11 AM
  3. Macro to create summary table
    By robertguy in forum Excel General
    Replies: 2
    Last Post: 12-14-2011, 06:11 PM
  4. How to create summary table from data using VBA
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-22-2011, 02:57 PM
  5. VBA Code to create summary table and Chart
    By KPK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2010, 05:40 AM
  6. Excel 2007 : Need help to create a summary table
    By Tidus1224 in forum Excel General
    Replies: 4
    Last Post: 06-27-2009, 04:06 AM
  7. Create a summary table from different text criteria
    By 247earnings in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-02-2007, 04:23 AM
  8. Create Summary from Table
    By karstens in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2007, 06:49 PM

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