newcat

I have this code below to where I select a name in cell I4, and then click run in cell f4, and this filters to that name in each pivot table on the page. This always worked before but all of a sudden stopped working? Also, is there a way I can write this to where if you just select another...

I don't have a lot of experience with VBA and there's one error that keeps bugging me. The following code does exactly what I want, with the exception that I get the "Method Intersect of Object _Global Failed" error every time I update cell B3. What am I doing wrong? I thought I was being...

Hello, I am giving up and posting as I cannot get the second part of this code to work within a Worksheet change, but it works when placed in a separate macro that I manually call. I need this whole code to run during a cell change. The Pivot Table piece works, everything after with...

Hello, I am creating a report with 4 criteria that the end user will be able to update via a data validation list on the primary tab. So far, I am only able to update the "VP" filter from the pivot table, but I'm trying to figure out how the other 3 cells can be used to update the other...

Hi, I have the following code that takes values selected via a list on a worksheet named "Trended P&L" that takes the value that's placed in cell D3 and uses that value to refresh a pivot table located on a worksheet named "Travel". Private Sub Worksheet_Change(ByVal Target As Range) Dim...

Trying to run the below macro to change a pivot table based on a cell and this keeps erroring out? Field.CurrentPage = NewCat Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'This line stops the worksheet updating on every change, it only updates when cells are touched If...

I'm very new to vba so bare with me :). I have column A that has all existing categories, new categories are listed in column C. I'm trying to determine how to take these new categories, and add them to column "a" if they aren't already in column A. In the example the new categories in column C...

Hi, I need some help with the following VBA. I'm using this to update pivot filters based on cell values located in H6:H7. As the values in this range are updated it automatically updates the filters on the pivot. However, the auto update doesn't work if H6:H7 are formulas themselves. If the...

Hello all! I am new to VBA I am trying to update multiple pivot tables on sheet "data", based on drop down list on sheet "Flash" to update graphs on sheet "Flash" as well. I found the code to update a single pivot table but editing it to do several gives me an error at pt.RefreshTable. Thanks...

I need some Newbie help. I have a code I put together from other post to filter a pivot table based of a cell's data. Now it works fine if I am filtering my "department" filter but I need to filer based off a date. I can't get this to work and it keeps showing an error on Field.CurrentPage = New...

Hi All, new here to the forum and was looking for abit of help i am fairly new to VBA and was wondering if someone could help with the solution to the following query: I have the below code to filter a pivot table using a specific cell reference in this case cell B3 in the worksheet "Front...

I'm trying to update the month of a pivot table based on what is in cell H6. The data source has a month column where the data is stored as text like so: May-2017. This is what I'm trying to work from: Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'This line stops the...