+ Reply to Thread
Results 1 to 2 of 2

Dynamic macro to subtotals and copy subtotals to another sheet for further processing

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,052

    Lightbulb Dynamic macro to subtotals and copy subtotals to another sheet for further processing

    Hi All Guys

    I have to 2 format templates sheets but same principle apply for both

    Make a subtotal of Tariff description origin header as the primary key with qty litres sugar and amount

    the other format does not contain litres and sugar but header column slightly differ see attached sheet

    One sheet expected results column headers O,P,S,T

    ANOTHER WORKBOOK sheet expected results column HEADERS L, M N O T V.

    Actually doing manually with subtotals, F5 SPECIAL VISIBLE CELLS AND COPY REQUIRED HEADERS TO SUMMARY.

    Looking for a macro to make dynamic subtotals for these colums mentioned above and then transfered it summary sheet for further process as it is repetitive process each time so as save me time I am overloaded andme crazy

    Note the subtotals can reach up 900 subtotals with a data set of 10000 to to 15000 rows .

    Hope anyone who knows vba to help me in this tedious task am looking looking to automate this process

    http://www.mrexcel.com/forum/excel-q...-criteria.html
    Attached Files Attached Files
    Last edited by JEAN1972; 11-22-2015 at 08:57 AM. Reason: additional post

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,527

    Re: Dynamic macro to subtotals and copy subtotals to another sheet for further processing

    Cross Posted.


    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this 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. create subtotals and copy subtotals to a new sheet with VBA
    By tonupgirl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2012, 01:36 AM
  2. Subtotals: Nested subtotals below higher subtotal
    By RobN in forum Excel General
    Replies: 1
    Last Post: 07-20-2006, 04:10 PM
  3. Questions: Copy ranges, autofilter macro, subtotals, & naming shee
    By Smangler in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2006, 12:40 PM
  4. Subtotals adding a description next to the subtotals
    By Jeanne in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2006, 07:08 PM
  5. Replies: 1
    Last Post: 06-20-2005, 07:05 PM
  6. [SOLVED] Problem with nested subtotals, placing secondary subtotals BELOW .
    By Dawn Cameron in forum Excel General
    Replies: 1
    Last Post: 06-03-2005, 06:05 PM
  7. How do I copy only subtotals to a new sheet?
    By darlinvee in forum Excel General
    Replies: 2
    Last Post: 05-27-2005, 06:05 PM
  8. [SOLVED] When using subtotals, how do I copy and paste only the subtotals .
    By Wendy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2005, 06:06 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