advance filer

Hi, I'm not sure what is wrong with the below code but somehow I'm unable to filter the options which I want to filter. Can anyone help? Sub AdvancedFilterExample() 'Define variables Dim ws As Worksheet Dim rng As Range Dim criteria As String 'Set the worksheet you want to...

Hi I have created an advance filter to filter out some values, but scenario where the macro does not find the filter criteria values in the excel sheet, it hides all the other rows hence wanted to check how I can make a macro in such a way that if it doesn't find the filter criteria value in a...

Hi everyone, Background: <tbody> A B C D Policy Issue Service Benefits Application Service Request Analysis underwriting Policy Accounts Payout Payment Admin </tbody> <tbody> </tbody> The Blue text in Column A is level 1 data; the red text in B,C and D column is Level 2 data...

Hi, I have a very large data set, 10,000 rows and 150 columns. I need to extract and display unique values from the rows. My data is arranged as follows. <tbody> A B C D E F G H I J 1 Boston 3 5 3 7 3 2 NYC 1 2 2 4 8 </tbody> Desired Result Display: <tbody> Boston 3 5 7...

Hi, I have an advance filter with criteria as follows: Range(ClientRange).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range(ClntName), CopyToRange:=Range("AA2"), unique:=True and it works just fine ... it copies the title and the data. But in the next case I have no criteria as...