Results 1 to 1 of 1
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Smile Macro to create Pivot Table

    I would like VBA code to delete the Pivot table sheets as Excel does not allow for the raw data to be imported and the raw data is manipulated by deleting unwanted columns and adding some new columns

    I would like VBA code to create two Pivot table sheets-see sheet "Purchases" & "FA-YTD Dep"

    The Pivot Table-"Purchases" must contain the following:Asset Type, Capital Cost, financial Year

    The Pivot Table FA-YTD Dep must contain the following:Asset Type, WDV, Capital Cost, total-dep

    I have attached sample data

    Your assistance in this regard is most appreciated
    Attached Files Attached Files
    Last edited by HowardC; 2012-08-01 at 14:23.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •