autofilter

I'm trying to filter a column (E) by the values found in a range and to change all visible cells after that search to a new style ("Good"). For some reason it only seems to be picking up the first row in the range when applying the filter. Does anyone know where I'm going wrong? (I've copied...

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...

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 =...

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"...

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...

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...

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.

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...

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...

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...

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...

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...

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)...

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 '...

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...

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...

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...

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...

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...

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...