autofilter

  1. airforceone

    AutoFilter Multi Columns with Date

    good day mate, need some guidance again, my code do run when not filtering between dates! but when I include the Date Covered in the range it does not show/filter intended record(s). Sub AutoFilterDate() Dim sDate As Long Dim eDate As Long sDate = Range("H1").Value eDate...
  2. A

    VBA Autofilter partial match in two column

    Hi all, I want to use the autofilter for partial match in two columns, it not works for two columns but works for one column. May I know how to revise the code? Sub Search() Dim Mws As Worksheet Dim PR As Worksheet Dim Rng As Range Set Mws = ThisWorkbook.Sheets("Data input v2") Set PR =...
  3. M

    Need to use AutoFilter on multiple tables within a single VBA code

    I have created a very simple VBA code that automatically applies a filter on the single column I have filtered on a table, which I have named “BB.Tbl1”. However, I want the VBA to apply to multiple tables that are all on the same worksheet, so I want it to include my other tables named "BB.Tbl2"...
  4. M

    Specific columns from auto filter range - VBA

    Is there a way to only copy certain columns from an auto filter? With the below example the active sheet has 8 columns of data G, L, P, R, S, T, W, AB (other columns have been hidden) When I copy the data, I don’t want to copy column W & AB so that only 6 columns of data will be moved to...
  5. N

    Excel Macro how do I filter time using VBA to copy/paste to different sheet

    I'm trying to use VBA to automate a process I perform multiple times a day. I've figured out a little bit but I've got 2 different columns containing time. The estimated time is sometimes populated so I want to be able to filter on 2 conditions: either ET (Estimated Time) is populated and...
  6. A

    Excel VBA: Loop through autofilter problem

    Hi all, I want to loop through autofilter criteria in column G( below photo) and do something, such as copy or sum. How can i loop each choice in VBA? Thank you very much for your help.
  7. J

    SUBTOTAL on filtered data issue

    Hi, I have a Subtotal array formula that is applied to a range of filtered data. It works when the data is positive, however, it doesn't seem to work when the data is negative. {=MAX(SUBTOTAL(104,OFFSET(AH15,ROW(AH15:AH21739)-MIN(ROW(AH15:AH21739)),0,1,1))*(AH15:AH21739<=AH8))} Essentially...
  8. S

    Autofilter date range not showing correct results

    I'm running the attached code, it is applying the correct filter on the correct column but the results displayed are incorrect. When I manually apply the same filter, the correct results are displayed. This is very strange and I don't understand why this is happening. Any help would be greatly...
  9. S

    Unreliable Autofilter with multiple IF statements

    Hi, I'm trying to filter a sheet using a userform, the user clicks a checkbox on the userform and the filter is applied immediately. It was working fine until a number of columns need to be filtered with the word "Valid" instead of just not blank. If the Checkbox is selected, check if that...
  10. Y

    Need a Macro code to filter & unselect a specific value.

    Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task. Consider following example. Name Devices code A Desktop 234 B Laptop 2345 C Laptop 3456 D Smartphone 7654 E Printer 3456 F Desktop 098 G Scanner 123 H Laptop 65 I Smartphone 876 J...
  11. Y

    Macro code to autofilter & select dynamic data.

    Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task. Consider following example. Name Devices code A Desktop 234 B Laptop 2345 C Laptop 3456 D Smartphone 7654 E Printer 3456 F Desktop 098 G Scanner 123 H Laptop 65 I Smartphone 876 J...
  12. T

    C# Office.Interop.Excel How do I loop through the AutoFilter'd returned rows?

    I have created the following AutoFilter: C# excelRange = excelWorksheet.get_Range("G1"); excelRange.AutoFilter(Field: 7, Criteria1: "Part Number"); excelRange.AutoFilter(Field: 7, Criteria1: ">A*", Operator: Microsoft.Office.Interop.Excel.XlAutoFilterOperator.xlAnd)...
  13. E

    Autofilter VBA - Defaults to US date format

    Hello! I have made a VBA to autofilter based on a date in cell D5. The problem is I'm in the UK and it's taking dates such as 01/04/2022 to mean 04/01/2022. Is there a ways to force it to recognise the British date format? Sub DateFilter() ' ' DateFilter Macro '...
  14. F

    Toggle Auto Filter On and Off with specific parameters

    I am using the below code to toggle on and off filter showing current month. The code works with the exception it leaves the sheet without filters. I would like thist to leave AutoFilterMode=True once run. Sub Toggle_Current_Month() ' ' Macro to filter current month basis BOL Date ' With...
  15. N

    Notes "crushed" by Autofilter--How to prevent?

    I frequently use autofilter on tables/lists containing cells with attached notes. Excel has this *maddening* behavior of changing the size of the attached note based on how many rows have been filtered out. I have attached (in pictures) a sample small table I created with names and ages. I...
  16. N

    Filter a Pivot like AutoFiltering non-pivot data via VBA

    I have tricked a pivot-table to search in value fields and item-fields like a manual auto-filter. I did this by applying a manual Autofilter on the Pivot Table by using this solution. Now I can filter all columns like a regular AutoFilter which simply hides the rows during a filter instead of...
  17. H

    How to speed up a file when autofiltering

    Some of the sheets I have compile annual data and and up being maybe 120,000 rows. Many of them work fine when autofiltering, but am having some difficulty with this one and wonder what might be wrong. The sheets is only 80,000 rows as it is only September, but when I try to autofilter, it...
  18. T

    autofilter partial match

    Hi there, I'm new to visual basics and I'm trying to filter my data so it will show up as the User searches for it. However, I want the User to be able to search for partial matches. Example: Product Number in the table is 1234567 I want the User to be able to simply search for...
  19. tlc53

    AutoFilter - Hide particular category

    Hi there, Can someone help me fix this code please? Step 6 is the bit that's not quite right. Instead of showing the AutoFilter categories selected, I want it to hide category "ZZZSpare". Thank you! Sub Prepare() ' ' Prepare Macro ' '1) Select table "Member_Table_Subtotal" Application.Goto...
  20. A

    Excel VBA: Loop through autofilter criteria to copy and paste to new sheet then save as new file.

    Hi all, I want to loop through autofilter criteria in column G( below photo) to copy and paste to new sheet then save as new file. Below is my code, i know that it can use if and else to do, i want to know how to change to use the loop. Thank you very much for your help. Dim wb As Workbook...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top