+ Reply to Thread
Results 1 to 2 of 2

VBA to fill the calculation formula in pivottable2

  1. #1
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    VBA to fill the calculation formula in pivottable2

    Dear expert

    I have pivottable2 which have calculation of daytoday activity i want fill formula in pivot table2 in range In AO&AP wherever find total of type according segment.
    formula in AO sum of segment term{1,3,12}+{24}+{36)
    AO=SUM(C68:E68)+SUM(I68:K68)+SUM(O68:P68)+SUM(T68:V68)+SUM(Z68:AA68)+SUM(AE68:AG68)+F68*24/12+G68*36/12+L68*24/12+M68*36/12+Q68*24/12+R68*36/12+W68*24/12+X68*36/12+AB68*24/12+AC68*36/12+AH68*24/12+AI68*36/12

    AP=AO68-AM68 where ever find total of type.

    find the attachment
    Attached Files Attached Files
    Last edited by johnmacpro; 07-26-2016 at 03:39 PM. Reason: brief

  2. #2
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Re: VBA to fill the calculation formula in pivottable2 and compare pivot1 and pivot2

    Any experts Help on this?

+ 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. Compare two ranges using the fill color changes
    By Remphan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-08-2016, 10:29 AM
  2. [SOLVED] Formula to compare last 2 numbers in row for upward, downward trend calculation
    By Zyphon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-26-2015, 10:10 AM
  3. Replies: 5
    Last Post: 04-05-2015, 04:09 PM
  4. Mpg partial fill up calculation
    By Blueagle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2013, 12:15 AM
  5. PivotTable2 Is Listed First
    By goss in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-30-2013, 05:55 PM
  6. Compare and Fill from Two Workbooks
    By elite-fusion in forum Excel General
    Replies: 2
    Last Post: 04-01-2011, 03:41 PM
  7. Replies: 0
    Last Post: 03-05-2005, 06: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