filter criteria

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

Hi Guys, I would like to request your help with this macro. I tried several times but I'm not sure how to do that . I need to filter for a customer and select 20 materials minimum for each one. Note : I have around 100 different customers Customer Materials...

Hello, I never excel scripted before.. so I am looking for some help with a macro, I created a workbook with a company inventory of all IT items.. each sheet has a listing of a certain type of device (workstations/switchs/keyboards/monitors/printers ect). I have a query that is activated by a...

I am working on a series of Gantt chart reports where one of the requirements involves the end-user entering one or more "employees" to view all of the programs assigned to them. I can’t seem to filter on the Lead/Test field if the cell isn’t exact. I am also filtering only on the last...

I am trying to filter out data based on specific data that changes based on location, I am trying to see if their is a way to adjust the filter code to use the data on a list I created as the filter criteria, once it has gone through the whole list it would continue with the rest of the macro...

I'm trying to use a adv filter to pull out, in a separate table, items from a table which meet a criteria based on a formula ie. the criteria should look at 'starting column' F, and is only if that number is smaller than the sum of columns D & E. If tried a IF Formula but cant seem to get it...

Can anyone point me in the right direction to write a macro that filters my table by the values currently selected? Currently, to filter my data I have to click the filter arrow on ColumnA, un-select the "select all" box, then scroll through the list to select the value I want to use in the...

Hello, I require a macro to hide entire rows based on the criteria of having blank values in BOTH columns C & D. Thanks in advance BENR

Hi The following code is quite straight forward and looks for 2 criteria using a filter within some data but I need it to look for more than 2 criteria now as the report is growing... Selection.AutoFilter Field:=10, Criteria1:="=SERCO", Operator:=xlOr, _ Criteria2:="=NG" I have...

I have an autofilter setup with 3 values: "Show", "Hide" and "Always". The show/hide values are dependent if formulas based on other cells. I have two sheets with this filter (Template and Summary); the filter works fine on the Template tab, however on the Summary tab... When filtered to...

Hi guys and girls, sorry for the re-post but I just figured out how to share my file on Windows SkyDrive. https://skydrive.live.com/redir.aspx?cid=4cdbd283ac4cd6f6&resid=4CDBD283AC4CD6F6!102 In the attachment you will find a list of products named "list." The first column is the product...

I have a master list of all of our parts for our inventory system as seen below <TABLE style="WIDTH: 959pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1279><COLGROUP><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH...

Hi everyone, I can't figure out how to do that: I have the records of a flow of foretasted price. Means that every 2 minutes I have new price coming for the same point of time in the future. My goals is to extract of every period of time the latest foretasted point. As the last forecast should...

I have 3 sheets, all with the same headings. I need a pivot table which can take the data from all three sheets. <TABLE style="WIDTH: 326pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=435><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 62pt...

I'm trying to improve my macro to run a filter on Col Y and delete specific values. Col Y can be "DT", "IO", "PS", "RO", "TI", "TO", "WO", "ZZ" "(Blank)" but I only want to keep "IO", "PS", "RO". I tried putting a space into each cell in the entire row where there is a value I want to delete...

Hi there, I know absolutely nothing about excel and I have quite a difficult – for me at least – thing I want to do. I have a file in which every row has 40 columns, and in some rows all the columns are filled in, in some only one, some multiple, you get it. What I want to do is filter the file...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hello! Would appreciate any help...have searched the previous posts without luck... Am using Excel XP Q1: i want to filter out duplicate cases in a specific column where constant data e.g. 'age' is unchanged for a particular case. I have tried C&P to a separate doc, advanced filtering showing...

Hello Everyone, I have a fairly standard macro that uses autofilters using different variables to filter out the data, but then after that it needs to manipulate the rows that still visible, I have found this basic code from other posts that moves down the data untill it reaches a visible row...

First I want to say thank you for everyone on here. I am not new to excel, but I am new to what it can actually do. From reading the posts on here I have learned a lot about how powerful excel really is. I have been creating a spreadsheet that enables engineering to sort thru a large amount of...