+ Reply to Thread
Results 1 to 9 of 9

Need formula of VBA whereever find total in A:A

  1. #1
    Registered User
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2007
    Posts
    68

    Need formula of VBA whereever find total in A:A

    Dear experts

    good to all

    I have range of data copied from pivot i want apply some calculation with formula if its possible apply vba

    i want calculate only Subtotal values where find string along with total like "US Total"

    under month there is Week number like 1,3,7,10,12.

    i want start with date 1-Feb-15 sum (1,3,7) and sum(10/24*14) and sum(12/36*14)
    1-Mar-15 = sum (1,3,7) and sum(10/24*14) and sum(12/36*14)
    1-Apr-15 = sum (1,3,7) and sum(10/24*14) and sum(12/36*14)
    Last two row1-May-15 = sum (1,3,7) and sum(10/24*13) and sum(12/36*13)
    Last row1-Jun-15 = sum (1,3,7) and sum(10/24*12) and sum(12/36*12)

    Like date start with any date start for 10&12 for 10/24*14 & for 12/36*14 last two date segment i want 13&12

    find the attachment brief explanation given
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2007
    Posts
    68

    Re: Need formula of VBA whereever find total in A:A

    Any experst help on this?

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,515

    Re: Need formula of VBA whereever find total in A:A

    I have range of data copied from pivot i want apply some calculation with formula if its possible apply vba
    where do we find the pivot, what actions need to be done.

    So more general, the question is not clear, at leat not to me.

    Show it in a small excel file, and mark related cells with the same color.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Registered User
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2007
    Posts
    68

    Re: Need formula of VBA whereever find total in A:A

    I just want calculation after grand total in pivot. find the attachment sheet Pivot_ @ column T:T is my requirement.

    my main requirment is if extra data added in pivot how does formula or vba get works.
    Attached Files Attached Files
    Last edited by julielara; 07-31-2016 at 05:28 AM. Reason: attachment

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,515

    Re: Need formula of VBA whereever find total in A:A

    Ther is no sheet Pivot_ @ in your file !!!

    Edit

    Show it in a small excel file, and mark related cells with the same color.
    I don't see the color of the related cells either.

  6. #6
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Need formula of VBA whereever find total in A:A

    @oeldere, I think the @ relates to column T:T i.e. "@ column T:T", there is a sheet called "PIVOT_" which has a pivot table
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  7. #7
    Registered User
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2007
    Posts
    68

    Re: Need formula of VBA whereever find total in A:A

    Sir will u not see the pivot table In sheet Pivot_ In column T:T i want calculation with formula towards every subtotal of country. and find the explain sheet which brief my requirement if data get more in pivot

  8. #8
    Registered User
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2007
    Posts
    68

    Re: Need formula of VBA whereever find total in A:A

    Any experts help on this????

  9. #9
    Registered User
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2007
    Posts
    68

    Re: Need formula of VBA whereever find total in A:A

    any experts help on this urgent requirement!!

+ 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. Would an array formula be useful to find the total?
    By seoer in forum Excel General
    Replies: 5
    Last Post: 05-26-2016, 10:56 AM
  2. Need formula to concatenate of header value whereever of range having 1
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2016, 12:55 AM
  3. [SOLVED] Formula to Find Total Number of Different Value Variations
    By artiststevens in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-07-2014, 04:04 PM
  4. VBA formating whereever text is found kept in code
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-11-2013, 01:24 AM
  5. Using a formula to find a total from three rows
    By patsyhixon in forum Excel General
    Replies: 7
    Last Post: 01-16-2012, 11:17 AM
  6. Find Total row and insert formula
    By soss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2011, 09:09 AM
  7. [SOLVED] a formula to find total compound amount after given number of yea.
    By ronan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2005, 05:06 PM

Tags for this Thread

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