+ Reply to Thread
Results 1 to 1 of 1

VBA for computing variance analysis

  1. #1
    Registered User
    Join Date
    01-09-2015
    Location
    Germany
    MS-Off Ver
    MS Office 2010
    Posts
    33

    VBA for computing variance analysis

    Dears,
    I am new here but hope to receive good advices how to solve my challenge to automate the variance analysis based on a pivot table with VBA code.
    Unfortunately I am beginner in VBA programming, hence my request here for some support.
    I have attached an excel file with an example and a word document to describe the "wishes".
    I am aware that this is too much to ask whole programming in such a forum, therefore it would be already very glad for a help how to coompute via VBA the formula written in sheet "Pivot_CA3COPG", cell T18 (volume effect).
    Furthermore it would be as well great to have an advice or even code how to change the order of the fields Customer Aggregate3, Country and ProductGroup (6 possible orders) and bringint it back to the first order - after each calculation of the variance analysis and transfering the data into the summary sheet.
    Thanks for any support!
    Best regards
    Heinz
    Attached Files Attached Files

+ 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. VBA for Variance Analysis
    By megaheinz in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-09-2015, 05:56 AM
  2. Very difficult variance analysis for
    By amartino44 in forum Excel General
    Replies: 0
    Last Post: 12-05-2013, 06:04 PM
  3. [SOLVED] Need help with VLookup to complete variance analysis
    By Rahulsharma in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-23-2012, 03:21 AM
  4. Variance analysis
    By rhyan66 in forum Excel General
    Replies: 0
    Last Post: 04-18-2011, 11:14 AM
  5. Variance Calculation and Analysis
    By Mayank Trivedi in forum Excel General
    Replies: 3
    Last Post: 05-03-2010, 01:15 PM

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