field=1

Hi I've recorded a macro which filters blanks in a sheet. However, I need to modify it, so that it deletes the blanks from the range in the sheet regardless of the number of rows. Does anyone know how to modify the code below, please? Also, is there a good tutorial on VBA autofilters that...

Hi all, Happy Friday. I'm trying to record a macro that filters a table to any rows with a "D" in the designated row and then deletes the visible rows, unfiltering the table before ending the macro. I am using the below but it is failing on the "Selection.EntireRow.Delete" command - is anyone...

Hello all, I have quick question. I am struggling with autofilter in vba. I have following code: itm is shift code, which can be xxx, aaa, bbb, ccc etc... FilterArr = Array("*" & Itm, "*" & Itm & "/*") FilterRng.AutoFilter field:=1, Criteria1:=FilterArr, Operator:=xlFilterValues...

Dear Expert I have to filter my worksheet quite frequently on the basis of value in the last cell of a column. Please help me form a vba for that. I'm sharing the amount of work I was able to do... Thanks a lot ? Range("Visits[[#Headers],[Sr]]").Select Dim varSr As String...

Hi all, I need to add code to loop through the code below, but I'm not exactly sure how to do this. Any help would be greatly appreciated. What this is currently doing (In excel) is filtering on column "H" to find the criteria "No Match". Once found a new row is added to my table in within...

I would like to autofilter with 5+ criteria, but my code falls over if I try more than 2. is there a work around or alternative method without stepping through each line? Works Sheets("data").Range("A:P").AutoFilter Field:=1, Criteria1:="<>R2*" _ , Operator:=xlAnd, Criteria2:="<>T2*"...

So I keep getting an error 1004 on this line when I want to filter a drop-down set from cell C4 - any ideas why? Sub Update() ActiveWorkbook.RefreshAll Columns("L:L").EntireColumn.AutoFit Selection.EntireColumn.Hidden = False ActiveSheet.Range("$L$4").AutoFilter Field:=1...

Hi All, I am trying to write the VBA code to do the following. I want to hide specific rows from a Filter drop down box, based on criteria in a range in a different sheet. Criteria in Sheet 1 (Parameters), range "B2":"B12" For each "Y", then select that criteria in sheet 2 (Budget) "B1" -...

I'm trying to filter data based on a user's selection. The user may select more than one criteria. I have a column called "PRODUCTS" containing a number of values (e.g., PRODUCT 1, PRODUCT 2, etc.). I have 11 checkboxes (on the sheet itself, not a userform), each representing a product in that...

I have problems when applying the following code ActiveSheet.Range("$A$1:$B$7").AutoFilter Field:=1, Criteria1:= _ "<01.08.2018", Operator:=xlAnd When the macro activates the filter. All values are filtered and are not visible in the list (values larger, equal and lower than...

Hi all, first post on here.</SPAN> I’m having trouble cracking the VBA code I need to allow a user to select a region name from a drop-down list on Sheet1 that will filter results (based on their selection) in 9 other named worksheets (Week36 through to Week44). </SPAN> The drop-down list is...

Hello, I have a workbook that is used to bring in raw data for POS transactions from multiple locations. The macro used is to filter the data on a summary page as well as on individual worksheets for each location so on each worksheet only that location's transactions show and they are...

Hello - I have multiple sheets where I want to apply a filter and unfiltered, the location for the filter is the same across all sheets and range is the same BW8:BW400. I recorded a macro for three of the sheets to select the filter and looks like this (see below) but is there a way to...

I used the Macro Recorder to get the basics, added in for Criteria1 and Criteria2... All worked good till I needed to select certain rows and available cells... Here is the code I am using with all the "Failures" for selecting the ranges.. Application.ScreenUpdating = False Dim Startdate...

Hello, I have 2 sheets, Sheet1 "Capture" Sheet2 "BD TASK TRACKER". I am trying to have a link for each opportunity on Sheet1 that you will click and it will find the tasks associated with the Capture reference. Both sheets have the same format, Column A "Client" Column B "Title" ,etc. etc. I...

Column A contains these values: Name a b c d e I want to filter some values, so use this: Range("A1).AutoFilter Field:=1, Criteria1:=Array("a", "b"), Operator:=xlFilterValues which indeed does return the values a and b only. Question 1. Why does this return no values? Dim...

Hello, everyone, I ask for your cooperation because I have difficulty with one part in making a particular macro. I've found many ways to copy multiple worksheets into a new workbook, but then I have to leave specific data in it. Explanation: I have a master workbook with 86 sheets, 28 of them...

Hi all, My tables retrieve entries from the database through a dropdown list so they can have 1 to 500 entries therefore auto filter to remove blanks is inevitable. I have tables across many sheets however they don't start from the same row or column. In order to filter out blanks, I had to...

I recorded the macro below. I would like to change it so instead of the cell range identified, I would like it to run on whatever cells I currently have selected. Ideally, I would open a workbook with this macro, then open another workbook. In the second workbook I would highlight a range of...

I have created a search box which works well but after using the search box the selected text stays on the screen and will even appear on another excel file which is totally unrelated. This is what stays on the screen I will add the file to this post if i can so you can look at my code...