+ Reply to Thread
Results 1 to 4 of 4

Help to Create VBA codes as per all Category

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    321

    Help to Create VBA codes as per all Category

    Refer my attachment file.

    In this sheet name-Category which is final.

    I have attempted an excel sheet working i.e. Variance Qtr Wise and apply an excel formula .

    File has been very slow to save responded.

    Please help me to cretae VBA codes for that Automation includes all category.

    Format will be no same as shown in sheet 1.may be includes one or more sheet but category wise VBA codes.

    Is it possible in this VBA era ?
    Regards


    Pradeep Kumar Gupta
    Gurgaon ( INDIA )

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,909

    Re: Help to Create VBA codes as per all Category

    Use the following

    in C5

    =SUMIFS(Dump!$H:$H,Dump!$B:$B,$C$3,Dump!$F:$F,$C$2,Dump!$Q:$Q,$B5)

    in E5

    =SUMIFS(Dump!$O:$O,Dump!$B:$B,$C$3,Dump!$F:$F,$C$2,Dump!$Q:$Q,$B5)/10^7

    in F5

    =SUMIFS(Dump!$H:$H,Dump!$B:$B,$F$3,Dump!$F:$F,$F$2,Dump!$Q:$Q,$B5)

    in H5

    =SUMIFS(Dump!$O:$O,Dump!$B:$B,$F$3,Dump!$F:$F,$F$2,Dump!$Q:$Q,$B5)/10^7

    Repeat the above for the other SUMPRODUCT formulas (C42,D55 etc)
    Attached Files Attached Files
    Last edited by JohnTopley; 06-22-2022 at 04:20 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    321

    Re: Help to Create VBA codes as per all Category

    Thanks for the help.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,909

    Re: Help to Create VBA codes as per all Category

    If you are happy with the solution, please mark as SOLVED: see "Thread Tools" at top of page.

+ 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 Table for each category in Column F
    By RusticWall in forum Excel General
    Replies: 1
    Last Post: 04-17-2021, 04:34 PM
  2. [SOLVED] Compare JSON data and splitting into corrected codes, deleted codes and added codes
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-01-2020, 06:46 AM
  3. [SOLVED] Compare JSON data and splitting into corrected codes, deleted codes and added codes
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-29-2020, 12:06 PM
  4. [SOLVED] Create a cumulative sum within a category
    By BFernandez in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-11-2014, 08:24 AM
  5. Replies: 3
    Last Post: 10-26-2014, 10:45 AM
  6. Create new Excel file based on category
    By Jcolby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2009, 01:28 PM
  7. How to create own category for my udf's?
    By vbfortran in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2008, 06:23 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