.position

Hey guys, Ive basically recorded this macro and want to make it dynamic to sort through lots of data. Basically I want to filter the data on one tab and limit it to one voucher and that voucher should have only one signedamount. Then I want to copy and paste that data onto a new tab that has...

Hey everyone! I recorded a macro to create a pivot table (amongst many many other functions) and everything works except for ONE item in the pivot table. The line of code to include the pivot table "Months" above "Status" is not being read. I've putzed with it, and I cannot seem to figure out...

I’m getting back into VBA after several years away. Refreshing my memory is harder than I thought. I’m creating multiple pivot tables from the same data sheet (“SOW Detail”), and inserting them one after another on “Sheet2”, with 3 empty rows between them. The macro recorder is not capturing...

Hello, I have a shared macro enable excel workbook where the code runs perfectlyfine in my computer, but when another coworker runs the same macro using the sameworkbook, they get an error message when it comes to creating the pivot table(in red below). Why would it work perfectly fine in my...

Hello, I have a vba code that inserts a pivot table and in a section it willfilter the data by a specific field. My issue now is what if in the data thatspecific field is not available. How can I write in vba code if “Watchlist” isnot an option then leave the pivot table blank? This is the...

Trying to make the following code work but not able to create the pivot Any ideas? Sub Pivott() Dim PSheet As Worksheet Dim DSheet As Worksheet Dim PCache As PivotCache Dim PTable As PivotTable Dim PRange As Range Dim LastRow As Long Dim LastCol As Long On Error...

Alright so I've written 90% of my program by hand, and I figured one part that would be ideal to simply record once all the manual sorting is out of the way would be the Pivot Table formatting. For some reason, I get the following error from the below code: Runtime Error 5: Invalid Procedure...

Dear all I want to generate multiple columns in Pivot table from single data column with each data type as a column header. I could do pivot table, but not sure how to proceed on this. 'Insert Row Fields With ActiveSheet.PivotTables("PT1").PivotFields("username") .Orientation =...

Hello, I am seeking out the help of someone here. I am utilizing the code attached to create a pivot table. All was working great, but now a week later I cannot get it to work at all. I constantly get Run-time error '1004' I know its because a portion of my code is not being executed and...

Hi Gays i am beginner with VBA Code so please i ask your help to how to make below code of create pivot table with dynamic range: Sub Pivot_Data() ' ' Pivot_Data Macro ' ' Range("A1").Select Selection.CurrentRegion.Select...

Trying to modify VBA in macro that we use to produce payroll data. The report process generates an Excel file, but it has 2 issues that I need to solve. 1. Stop deleting first 4 rows. 2. Stop deleting any columns. The original report (from Pentaho 3.8) creates extra columns and merged columns...

I have the following code below which works perfectly to update the Pivot tables Sub Update_Pivot() Sheets("Pivot Table").Select ActiveSheet.PivotTables("PivotTable4").ChangePivotCache ActiveWorkbook. _ PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "C:\My...

Hello once again All, well the Title says it all Here my code: Sheets("Anzahl_Kategorien_je_Kunde").Select Dim PvData As Range Dim PVLastRow As Longt PVLastRow = Range("A" & Rows.Count).End(xlUp).Row PvData = "'Anzahl_Kategorien_je_Kunde'!A1:H" & PVLastRow Cells(1...