Forum

Hi Richard, You can trap the error that is generated when you try to set the filter to a value that isn't in the source data. When this occurs you...

Hi Richard, I'm still unsure as to where the values for the filter are coming from, specifically for companies that aren't in your source data. ...

Thanks Richard. So what you are saying is that if you have a company '200' that isn't in the source data, you want the pivot table to set the filter ...

Hi Richard, no file attached. A video showing how to attach a file can be found here Regards Phil

Hi Leanne, No file attached 🙁 You need to click on the upload button Regards Phil

Hi Richard, There's not enough info here for me to understand what you are trying to do. If you want to filter a pivot table to only show 100 th...

Hi Robb, With detective work! 🙂 The first thing I did was create a table showing me the errors. You can do this by clicking on the number of ...

Hi Karthink, Please refer to Forum Rules and Guidelines This looks like a homework question. Whilst we are happy to help you if you are stuck, w...

Hi Poh, I'd probably use SUMPRODUCT but I don't clearly understand your question. What is it you want to sum, the Amount? If so, how does F c...

Hi Chris, It will be much easier, and new rows added to your source table will be automatically included in the final report, if you create a pivot...

Hi Oscar, Just change the IF statement in the Worksheet_Change event If (Not Intersect(Target, ActiveSheet.Range("DV_Range")) Is Nothing) Or (No...

Hi Chris, the output table in the workbook isn't in a tabular format so it's not in a layout that can easily be used with pivot tables etc. The ...

Hi Robb, Your PT will only display the data you feed into it. So if you want to show all dates in a month, you need to have all those dates in the...

Hi Christine, This post has code that creates PDF's VBA to Create PDF from Worksheet and this one has code to automate Pivot Tables VBA to...

Hi, The 3rd word in your list is cats and ~c?t matches the cat part, so replacing cat with cass you get casss cats casss Regards Phil