autofilter criteria

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

Hello seeking help for a code I've gathered. So the code below works well if the criteria are on the same sheet as the table. But I'm trying to figure out how the below code works if the criteria are on the different sheet. The Criteria: 10/8/2022, 10/9/2022, 10/10/2022 Code: Sub Test () Dim...

Hi, I am trying to filter two columns, one an effective date, the second an expiry date, to filter permits that were valid for a particular year. As the year of interest changes I have set up a userform which I can enter the year of interest. I am successfully able to get the first filter >=...

I keep getting AutoFilter method of Range class failed message. I'm following a tutorial online and I did everything as it's mentioned there but I just can't understand what I wrote wrong in this part. Any help? Sub Show_Sale_Purchase_Data() Dim dsh As Worksheet Dim sh As Worksheet Set dsh =...

Hi All, I have a question. So I am trying to make a VBA with filters. If the result met the condition, it shows YES. If the result doesn't meet the condition, it shows NO. The next step that I'm confuse is, if all the results are showing as NO, then I want it to Exit the Sub. But if there's...

Dear All, My aim is to create procedure, which makes always filtering for one criterion (on the column I), but makes next one filtering for criterion (in the column T) provided that it exists. To start with, I would like to add that I am a beginner in this and it is difficult for me to...

Mornin Ya'll. I've got a question on sheet 2 asking for a pressure, and a column on sheet 1 with multiple flange ratings. What I'd like the script to do is filter the flange ratings based on the pressure entered. For example, if the user entered 350 psi it would filter out everything below...

Hello all, I am stuck on an autofilter issue. I am trying to add criteria to an existing filtered column named "Interval". I have an Excel table with a column containing string or numeric data (see table below). I need to filter and return all records that are contained in the array (note I...

Dear All, I have the below code which applies a filter and copies the visible range after filtering. I now want the code to be updated to only copy columns A,B,H,I and BA. Please help. 'Macro to apply filter and copy the selection Sub Copy_With_AutoFilter1() 'Note: This macro use the function...

Dears, I'm a super noob with excel vba macro, I was able to write some codes time to time by adapting already existing ones from the net or via macro recording. This time I was not able to find a solution wandering through the net, I'll try to explain what I would like to achieve. I have an...

In one database I use a generic model number. In another, I have a specific model number. I have established criteria in the generic model number that is used to tie that data to the specific data. For example: Generic Table TIM(A,B,C) TIM(D,E,F) Specific Table TIMA TIMB TIMC TIMD TIME TIMF...

I am trying to export data from a master workbook, into my current workbook, based on 2 values in my current workbook. Current Workbook: C1: Employee C2: Bob D1: Month D2: July Workbook I need to get data from: V1: Employee S1: Month Is there a way to write a macro in my current...

I need code to activate autofilter allowing the user to select criteria from a specific Field. I'd hoped to simply activate the autofilter and pause execution while the user selected the appropriate criteria and then processing would continue. The sole reply to my prior post suggested...

Hello, I am trying to figure out how to make excel run an auto filter on zip codes based on the data entered in another excel workbook. Sub ziptest2() ActiveSheet.Range("$A$1:$AK$104555").AutoFilter Field:=7...

Dear All, I am using an input box to get the user input. With the user input, I am setting autofilter criteria. Here is the code: Dim SelSeg As String ActiveWorkbook.Sheets("Jan 2015").Activate Range("a1").Select SelSeg = InputBox("Please enter name of segments for which you are...

Hello, I was using the following code in VBA to filter data NOT equal to FEB. .AutoFilter 1, "<>FEB" I now want to filter the same data in the same way but using a cell value as reference, so I found this on the forum: .AutoFilter 1, Criteria1:=Range("'Sheet 1'!A35").Text But where do I...

Hello everyone. I have two pretty similar worksheets, ws1 and ws2, where ws2 has only a subset of the columns that ws1 has. However, the columns that ARE available in ws2 as well as their cell content in all rows are identical to ws1. Both sheets have autofilters in all columns - I permanently...

<tbody> INPUT </tbody> <tbody> Fixture HS AS TEAM A v TEAM B 1 1 TEAM C v TEAM D 2 1 TEAM E v TEAM F 1 2 TEAM A v TEAM C 3 0 </tbody> Im looking to try and write a macro to autofilter a table based on the contents on the cell above. This cell is on a different sheet to the table I...

Hi All I am trying to write a macro the autofilters based on the user's selection. Here is an example. Column A Column B Row 1 Snacks SN1 Row 2 Snacks SN2 Row 3 Clothes CL1 Row 4 Clothes CL2 Row 5 Drinks DR1 Row 6 Drinks DR2 The user would run the...