filter advance

Currently have an excel sheet with 100+ names, a job course, start date of course, and end date of course. I would like to filter to see who is currently doing a particular job course. Individuals are required to do at least 3 job courses so a basic filter does not work in this situation since...

Hello I currently have the code however I would like to change it slightly. The line with ''''' Rather than the code perform this action "testCell.Offset(, 1).Value = "Key in the dependency ID" I would like it to filter another tab called "dependencies" (column A) by using the value in the...

Hi i'm trying to find a solution to a problem concerning the selection change event: i have a worksheet with a list of products and all the details related. on another worksheet i have the same products with other info. what i would like to do is clicking on the product cell in the first...

I wanted to give this code to people that like me had a hard time getting it to work correctly. The 2 codes work as function in an Excel sheet and depending on parameter set, will return whatever has been filter on a particular field. 'Returns AutoFilter Criteria (Not to use on Tables) Function...

I want to make a filter to see rows that contain any chracter. For example, column A contains 124124, 4231, R2341, RRR Then I would like to see R2341, RRR from column A. Is there any way to filter only on character string? Thanks!

Hello All, I have 1 excel sheet in which there are around 1000 rows. The excel looks like <tbody> Name Age Roll No. Address abc 13 1 abc bcd 14 2 bcd cde 13 3 cde def 14 4 def efg 18 5 efg fgh 11 6 fgh ghi 19 7 ghi hij 16 8 hij ijk 22 9 ijk jkl 29 10 jkl </tbody> I need...

Hi I have 2 pivot tables. Pivot table 1 (TOPn) filters my top "BRAND - MODEL" field. I would like to use the results from that table. Let say a named range as the list can vary in length. Use those results in Pivot table 2 to filter the same field name "BRAND - MODEL". I've tried code from...

I have data from column A to J and there is ID number in column B .so on top of the sheet i want when i put the id number in Cell the data should show me regarding that id from column A to J on same sheet. <tbody> ID 123 </tbody> <tbody> A B C D J Date ID Data1 Data2 Data3...

Hi I search and found macro for creation sorted unique list and edit it to this code: Sub Macro22() Macro2 Macro With Sheet1 .Range("Names").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=.Range("AZ1"), Unique:=True .Range("FilteredNames").Sort Key1:=.Range("AZ2")...

ActiveSheet.Range("$A1:$W1").AutoFilter Field:=23, Criteria1:="Yes" Range("T1").Offset(1, 0).Select Selection.FormulaR1C1 = "=VLOOKUP(RC[-15],PV!C[-19]:C[-16],4,FALSE)" Selection.SpecialCells(xlCellTypeVisible).FillDown So far, I filtered my data where W = yes, and I am trying...

Sub reva() Dim LastRowColumnA As Long: LastRowColumnA = Sheets("Working Other Purchases").Cells(Rows.Count, 1).End(xlUp).Row ActiveSheet.Range("A1:AV" & LastRowColumnA).AutoFilter Field:=12, Criteria1:="=*Rate*", Operator:=xlFilterValues ActiveSheet.Range("A1:AV" &...

so i have an excel sheet with many employee numbers and first and last name of employee in one sheet on a second sheet i have only couple selected employees. How can i filter my main database to only those few workers on the second sheet. I have pasted an example. sheet 1 with all users...

Hi all, I have a (probably pretty stupid question) I work a lot with cleaning internal databases . I often have to filter out to particular job titles and one I always have a problem with is "IT" so that would be say and IT manager, a HEad of IT, an IT analyst etc etc etc (endless number of...

Hi: I have a dataset that contains baseball record, I want to pick only one team to look at, so is there anyway I can apply filter on HomeTeam and VisitTeam so that if either HomeTeam or VisitTeam contains the team name, say PHI, the who row stays? E.g: I have the data HomeTeam VisitTeam...

Hi - I have a changing string of text like computer coding. something like: ********> <!-- function sf(){document.f.q.focus();} function c(p,l,e){var f=document.f;if (f.action && document.getElementById) {var hf=document.getElementById("hf");if (hf) {var t = "<input type=hidden...

I am trying to figure out how to filter, cut and paste to new tab in worksheet. I want to delete the rows copied to the new tab. I am able to create and name the new tabs, now I need to filter for each variable. The number or rows for each changes weekly, but the variables filtered are the same...

Hello, I have data on sheet 1 which has one column with the country name. The data is for all countries globally. I am only interested in the data for EU countries. On sheet 2 I have a list of the EU countries which I would like to use to filter the data in sheet 1 so I only see the data in...

Hello! I am hoping to find some assistance in trying to create a tracker in Excel 2010. The tracker is designed to keep up with outstanding tasks for a project. Currently, I have it set up to calculate the "days til due" with the formula =B1-Today(1). The issue is that this seems to pull a...

Hi all and a happy new year! I am looking for help with a basic user form that has: 1x Combo box. 1x List box I need it to pull data from 4 columns on Sheet 1. If the combo box selection states "Factory" then it needs to pull the stated data below from the matches to "Factory" in Column I...

Hi Everyone, I am sending out Outlook appointments via a spreadsheet where all the data/information is stored. However, the issue I am running into is: when I need to send out multiple information to the same email address for a client, I want the client to get all of the information in the...