activesheet.pivottables

  1. S

    VBA: Error with adding datafields to a pivot table

    Hi guys, I have some code that does its job in adding datafields to a pivot table. I linked it with a form control button: Sub PDA1P() ' ' PDA1P Macro ' Adds all 1P PDA columns into values of PT ' ' Keyboard Shortcut: Ctrl+Shift+P ' ActiveSheet.PivotTables("SpendTable").AddDataField...
  2. O

    Macro's errors

    Is it possible to create a Macro that will sort some data, then used this sorted Data to create a Pivot table, then using the results of the pivot table, pasting the results as values then creating another pivot table? All this is done on the same sheet. I have tried to create this macro and...
  3. M

    Recorded Macro

    Hi I've recorded the following Macro in a workbook called SCSGroupageT which is obviously referenced in the code. How do i need to amend the code so that it will run in any workbook? Thanks Sub Testvba() ' ' Testvba Macro ' ' Range("A1:I2656").Select Range("C4").Activate...
  4. 0

    VBA Pivot Table

    Hello I have made a pivot table with the code below but when i add a new date "rows" the new data didn't appear in the pivot table how to Fix it ?? Range("A5:S1000").Select ActiveWorkbook.Worksheets("PIVOT1").PivotTables("PivotTable2").PivotCache. _ CreatePivotTable...
  5. H

    Dynamic selection Pivot

    Hi, I am trying to Run the dynamic selection Pivot tab,its reflecting a error as Invalid procedure call or argument I have bolded the code lines which reflect error .I am unable to figure out what went wrong. Sub Macro2() ' ' Macro2 Macro ' ' Range("N3").Select...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top