advanced filter

Hi, I am trying to pull data from a closed workbook using advanced filter. here is what my code looks like right now. It works fine if I have both the workbook with the criteria as well as the workbook "ORDERS CHART" open Sub Macro1() Range("Sheet2!A1:AU999").Clear...

I have an advanced filter running. I'm trying to get it to copy to another sheet WITH the comments. How do i alter my code to get it to do this? FinalRow = Range("Sheet1!A1").End(xlDown).Row Range("SSLFirst!A1:I999").Clear Range("Sheet1!A1").Resize(FinalRow, 9).AdvancedFilter _...

I have 2 columns Say A and B . Column A contains duplicate values whereas column B contains only Digit 1 or 2. i want to generate a list of unique values contained in column A for cells containing 1 and 2 in column b separately. I tried recording a macro using advanced filter but somehow it is...

I'm new to MrExcel.com, first post. I'm a VBA newbie. I'm tasked with creating a report of Client's with certain project statuses. I want to create this report on a separate sheet that already has some other data. The Advanced Filter almost does what I want, but it has two issues. I don't...

Hello, There are three list boxes on a sheet(Instruments,Months,Years). After the user selects items in each list box, selected items from each list box are copied into arrays and outputted into corresponding columns to be used as AND criteria for an Advanced filter. This set up works only...

I have a macro that advance filters some data according to a criteria range, and then places the desired fields in a data table on another worksheet. The advanced filter code is straight forward and works fine, but I notice that unlike when I simply copy and paste data into a data table, in...

I have 2 sheets, the first one "epacks" is populated daily from an online database and shows a list of parts that will be delivered to the factory with a corresponding epack# and a trailer#. The second is my "Interface" sheet in which I have 2 dynamic named ranges for my advanced filter...

I have a formula that looks for a certain word within a text string in multiple columns. small(if(not(iserror(search("house", B2:E50))),row(B2:E50)),rows($A1:A1)). This gives me the row number. It does not work with advanced filter. The intent is to filter on rows that may be contained in...

Both in Autofilter and Advanced Filters?

Hello, I'm new to excel vba and have been trying to write a code for filtering a worksheet based on exact match to my criteria range. For example, column L on my sheet1 includes D2-D26 and I only need to filter D2 and D20. But with the code I currently have I get all cells that start with D2...

Hey, currently doing Slaying Excel Dragons homework problem 84 which involves using advanced filter. As you can see, I want to set the criteria to Jo OR Fred but the result is also including "Joe" which is Jo plus an "e". Why is excel doing this and how do I stop it?

Hello, I've been searching a lot on the web to find help with this, but all the answers have been varied and I've not been able to get any to work. I have a single column containing text that I want to use advanced filter to 'copy to another location'. I need to ignore blanks and keep unique...

Hi all, With some minor experience with vba, I am still pretty new to excel, but a quick learner! Please keep that in mind as you read on. I have a bunch of data in a spreadsheet, and so far I've been able to create a user form to add entries to this data. :) Now, the next thing I want to...

I have 5 worksheets in a workbook, each with a table containing the same column headings and all tables begin at B12 and end at Col L. I would like to have the rows from each of the 5 tables copied to a separate master sheet. Also, each time the tables are updated with new data and/or rows are...

Hi, I have a range say A1:A100 that is populated with Client Names. I would like to use Advance Filter to copy unique values of Client Names to another Range ... say G1 and in another case H1. This is the criteria I have been testing for a while with no success: in Range B2, my criteria...

Hi, I need to build a complete non-blank criteria in an advanced filter. I know <> will give me all non-blanks (skipping pure blank cells). But as you see in the auto-filter criteria "Blanks" will also give the impure blanks (i.e cells containing only a space/spaces as thier value). How to build...

Hi, I´m trying to filter out unique names based on chosen year and organizational unit from a list that contains approx 20000 rows. Use code below, which is executed with a control button. I experience performance issues, the macro takes 5-10 sec to run. Is there any better way to do it? Sub...

Hi Guys, New to the site, really stuck with this excel filter problem. here goes; I have a spreadsheet which is essentially a table, table headers are in C7:I7 and the table cells are C8:I71. C8:I71 are all filled with a vlookup formula that pulls in information from other sheets. When the...

Hi, I am having problem with sorting the following rows according to its values in an ascending order. I would like to have it sorted based on the number before the first dot "x." then the middle number and finally the last number. I have tried filter, advanced sort, but I cant seem to get...

This is a self imposed project while I wait for information about my next real project. My team is at the level of using recorded code only, and I want to introduce using Advanced Filter to solving the following problem. An accounting group has daily cash posted that they need to reconcile to...