+ Reply to Thread
Results 1 to 3 of 3

Construct a VBA summary to main and name/part wise

  1. #1
    Registered User
    Join Date
    02-06-2025
    Location
    GURGAON,INDIA
    MS-Off Ver
    2021
    Posts
    16

    Construct a VBA summary to main and name/part wise

    Hello All,

    Good Morning

    Please refer my attachment file contains here 2 sheets,rest of the sheets have deleted but I will add later on and do not impact on this working.

    I am trying to construct a automate summary VBA from sheet name- combined on sheet name-Cash -del.

    1-AbsoluteSummary
    Column A=All the each stock name from Combined sheet.
    Columb B= sum of qty of each stock irrespective to name from combined sheet.
    Column C= sum of Total Value Plus Brokerage Columns of each stock irrespective to name from combined sheet And last divided by Column B against each stock qty.

    2-Summary of above further each name wise e.g.PKG,RG,AYU etc
    Column A=Each stock name from Combined sheet with name wise separeately.
    Columb B= sum of qty of each stock respective to name from combined sheet.
    Column C= sum of Total Value Plus Brokerage Columns of each stock respective to name from combined sheet And last divided by Column B against each stock qty.

    Having no idea ,how to prepare it ?

    Is it possible from VBA Codes ?
    Attached Files Attached Files
    Last edited by PRADEEPG1970; 06-30-2025 at 06:55 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,251

    Re: Construct a VBA summary to main and name/part wise

    Please Login or Register  to view this content.
    Attached Files Attached Files
    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
    Registered User
    Join Date
    02-06-2025
    Location
    GURGAON,INDIA
    MS-Off Ver
    2021
    Posts
    16

    Re: Construct a VBA summary to main and name/part wise

    Thanks a lot .

    Glad to find the nice help and oblige.

+ 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. I want category wise summary
    By btparkhe1920 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-05-2024, 03:55 PM
  2. [SOLVED] Month Wise Highest and Lowest Reading Summary
    By ranjan20 in forum Excel General
    Replies: 11
    Last Post: 03-04-2023, 02:00 PM
  3. Replies: 23
    Last Post: 06-20-2017, 04:17 AM
  4. vba code for automating branch wise day wise amount to summary file
    By pranithpm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2014, 04:18 AM
  5. [SOLVED] Require VBA working to construct the summary sheet with the help of date calculation
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-24-2013, 11:31 PM
  6. [SOLVED] I want change the data row wise to coloum wise & coloumn wise to row wise.
    By satputenandkumar0 in forum Excel General
    Replies: 3
    Last Post: 12-20-2012, 08:34 AM
  7. name wise Text summary
    By Charlie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2006, 04:45 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