Results 1 to 11 of 11

Multiplying An Excel Table Based on Subtotals

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2015
    Location
    TURKEY
    MS-Off Ver
    2010
    Posts
    10

    Multiplying An Excel Table Based on Subtotals

    Hi everybody;

    I have an excel table consisting of many changable subtables including formulas and hidden rows. Each sub table has its own subtotal row. As you can see in the sample file I want to split the table into seperate sheets based on the subtables. Now, I do this by copy past at each time. And the number of subtables may change. IWhat I want is to produce a separate page for each sub-table with the name of the table.
    You can see the sample file in the attachement.

    Thank you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with Pivot Table Formula based on subtotals
    By lisa6538 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-27-2020, 06:15 AM
  2. [SOLVED] Pivot Table AVG based on Subtotals
    By aetedford in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 05-16-2018, 06:22 AM
  3. Subtotals in an Excel table
    By tuph in forum Excel General
    Replies: 1
    Last Post: 08-15-2016, 10:05 PM
  4. Replies: 1
    Last Post: 11-24-2015, 11:58 AM
  5. Programmatically calculate subtotals for variable groups in Excel 2010 table
    By cbeh26 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-15-2012, 01:11 PM
  6. Formula for multiplying values from one table to another
    By Phatbrat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-30-2012, 05:01 AM
  7. multiplying based on a particular value
    By sjkiss in forum Excel General
    Replies: 10
    Last Post: 01-12-2010, 12:54 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