filter vba

I have a data like below I a VBA to Filter Names from List (J16:J20) One by One and then Copy the filtered data: CDEFGHIJKL1NameAmount2A53A54B105B106C157C158D209D2010E2511E251213Total Quantity15014Total Amount45001516A17B18C19D20E2122232425E13E13=SUBTOTAL(9,E2:E11)E14E14=E13*30

Hello, My code should filter each value and copy charts to different sheets. I looped this but it breaks mid loop. It works fine with 8 first values/sheets (should be 12 or so). I get error 1004: Select method of worksheet class failed. I highlighted the part in red when the error occurs. Sub...

Hi Excel Masters, I am working with a spreadsheet that does a data dump every month that is really messy, I'm trying to automate as much of the cleanup as possible. The only thing I'm stuck on with the VBA code is how to delete visible rows instead of specific rows as the number of rows with...

I have a workbook with an input sheet (sheet1) and multiple data sheets after that. Column X in each data sheet contains dates that are filtered. I have copied the following VBA code from another user to update the filters for the single date I want to filter in all sheets. It is as follows...

Hello Mr Excel, I have a tricky VBA code I'm trying to figure out, but cannot quite get the code to recognize my code for the dates. I'll try to clarify my issue and show blogs I've tried. I've build a table that includes 12-20 dates in the format YYYY-PMM so "Year"- "P" (Period) and "month"...

Hi guys, Could someone help me in this regard. These are the steps i'm trying to automate 1) Filter each unique value in column C 2) copy and paste the whole filtered data in an unique new sheet. 3) Continue till all the unique values in Column c are completed. 4) Perform arithmetical...

Does anyone know of a way to have the text of the filter parameter that has been applied to a chart to be displayed in a cell? I have my Pivot Chart title linked to a cell within the spreadsheet to allow for a dynamic title. I'd like for the title to also change as I select a new filter value...

I have a range of cells (tab 1) that has to be a filter in the principal tab. I have a pivot table based on the principal tab. The range of cells in tab 1 has not to considered on the pivot table. How I can create this type a filter? Regards,

Hi guys, is there a way in excel to open loop through a filtered column. I mean a way to select the values in a filtered column A one by one. example Column A (header) Dog Cat . . . mouse and macro to select the first value and than second value and loop until the last value Kind...