Results 1 to 13 of 13

Pivot Details into New WorkBook

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2010
    Location
    Finland
    MS-Off Ver
    Excel 2007
    Posts
    14

    Lightbulb Pivot Details into New WorkBook

    Hello,

    Just got my first problem solved and another one arises. (Thanks again to DonkeyOte)

    So with the code below I can now get pivot details with a mouse click and simultenously it deletes "unwanted" columns. This works perfectly.

    Now my question is : can I get pivot details open into new workbook rather than ?

    If this is possible, then the second question is as follows :

    This is not mandatory, but would be really cool.
    Is there a way to give the new workbook a name ? ideally it would be Waste Proposal + Current datetime.

    Sub Hylkyehdotus()
    '
    ' Hylkyehdotus Macro
    '
    
        Dim rngArea As Range
        With Sheets("TOY Mill Stocks").PivotTables("PivotTable2").TableRange1
            .Cells(.Cells.Count).ShowDetail = True
            For Each rngArea In Range("B:B,E:G,J:J,L:AZ,BB:BG").Areas
                rngArea.Delete
            Next rngArea
        End With
              
    End Sub
    Last edited by Magerator; 11-05-2010 at 07:48 AM. Reason: Tried to add the code tags...don't know if it's right now

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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