auto filter

  1. B

    Viewing Custom Auto-Filter, Please Help!

    All, I was sent a file from an associate that has the auto-filter on. I can tell that several rows of data are filtered out because there are gaps in the row numbers on the left side-bar. I also know which column was used to filter as it has the signature blue arrow (where as all other...
  2. mikecroom

    Accessing the unique possible values from an autofilter

    I have set up some VBA to set up a table with auto-filters (excel 2007) Now I want to access the list of possible values for one of the columns - as shown in the drop-down when you set the filter manually. Is there an object which provides this? I can't find one. I am looking under...
  3. M

    Vba Variable Filter criteria

    I'm currently working on a project of mine where I need my filter to exclude multiple values, The filter will constantly change and grow with the row head of the smallest value in a range. For instance: First step Filter on Column1 <> A , Then look for the minimum of Colum 2 Second...
  4. T

    User Form & Autofilter Problem

    I'm having a problem with the autofilter in my code. err number '1004' the table range is called "Smart" its three columns and about 8 rows in size. I've tried everything and can't find a solution. Any help will be greatly appreciated. If any additional info is needed let me know Private Sub...
  5. J

    Excel auto filter VBA code help needed

    I have a sheet with data in columns A thur F and the auto filter set on. In Column E (field 5) the sort is working well it filter all values as needed (I only wanted 0 selected). My problem is the next 2 sorts won’t work. <?xml:namespace prefix = o ns =...
  6. T

    How do I delete in the autofilter dropdown menu the sort options?

    When click on the auto filter drop down, the following 5 lines would show up and then the Text Filters shows. How do I hide those 5 lines so I can directly go to the Text Filters? Sort A to Z Sort Z to A Sort by Color Clear Filter from "customer" Filter by Color Thanks in advance for your...
  7. S

    Problems with multiple criteria using Autofilter

    Hi all, I am trying to use the autofilter to keep all the rows in the column range J:AA that have an "X" and discard everything else. I have this working fine with this code: Dim crit1, crit2, crit3 As String Dim raang As Range crit1 = "<>X" With Sheets(strMsg)...
  8. J

    Compile Error: Sub or Function not defined

    Hey all, I have a macro that filters out data using auto filter. Problem is once everything is complete, I only want to keep the visible cells and destroy everything else. So I added a For Each In loopm to iterate through active cells and set their auto filter mode to false, which hopefully...
  9. KG Old Wolf

    VBA Auto Filter with a Variable

    All, I've read through the posts yet I cannot see what I am doing wrong....spent hours before posting. I have a variable that I want to use in an auto filter. I've stripped the code to the barest minimum and still - no go. It is needed for use with a user form through wich the variable...
  10. G

    Refresh Autofilter Upon Cell Value Change

    I have a spreadsheet with a drop down box that has dates in it in C1. Below that I have data that I need to filter based on the date in the drop down box occurring between 2 dates listed in the data below it. I have already taken care of the date ocurring between the 2 dates by writing a...
  11. L

    Auto filter messing up my data

    Help! when i autofilter any column in my database it rearranges all rows - but i have formulas in one column that are dependent on other cells adjacent to it in a row, and that relative formula doesnt move with the cell! so when C3 at first = B3/A3 (let's say result in C3 is 0.32) after i...
  12. D

    Auto Filter

    Afternoon Orignally i was Auto Filtering a list where i was pulling data from a different workbook. I changed it so now that data is imported using sharepoint relationship. This works great. However i was using code to filter out data etc. Is it possible to use AutoFilter with a Defined...
  13. Y

    Auto Filter

    Hi Friends, i have a problem with Auto filter, i have made a file in which auto filter is disable or not working, but the same data copied in new sheet, then it is working as normally. can any friend suggest me what is the problem in my sheet.. waiting for your reply
  14. B

    Filter Specified Range

    Hello I have a spreadsheet that uses 700 rows. The last 20 rows contain formulas and values that I always want to keep visible. I would like to know if there is a way to limit the range that the Autofilter will act on. I want to filter the rows 3 to 680 and not filter the rows 681 to 700...
  15. D

    Using the AutoFilter/Custom Filter function in Excel

    <link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cdevray1%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/>...
  16. K

    Auto filter a table based on the value of a cell in a different sheet

    In Sheet1, I type in the following info: cell A1=EmployeeNumber, A2=Date, A3=Reason, A4=Tag. The info typed here are then saved to a database in Sheet2, i.e., column A=EmployeeNumber, column B=Date, column C=Reason, column D=Tag; this is done via macro when a SAVE button is clicked. What I...
  17. A

    data validation help

    Hello... does anyone know how to make a list data validation pick the information you want from your list by typing the first letter. For example.... autofilters allow only 1000 entries to be displayed. You can choose or "fast forward" to what you are looking for from the autofilter drop down...
  18. B

    Use Autofilter to Copy Cells from Column A

    I've been looking for a macro to copy my results from an autofilter from column A and paste them into a specific worksheet. Basically I have a main sheet that contains kit numbers across the top and part numbers in column A. If the part number is in that kit it gets an X. I usually use the...
  19. J

    AutoFilter with Dates

    I'm trying to use an autofilter to extract records that are more than a year old: Range("A1").AutoFilter Field:=1, Criteria1:="<11/24/2007" but when I run the macro I don't get any results. I would like to write a code that will do this everyweek when I run the macro so that I don't have to...
  20. A

    advanced autofilter

    I have a spreadsheet that I download from a database that has thousands of combinations. I know that on a small scale I could create named ranges and create a conditional autofilter, but that will not work in this case because there are so many combinations and the spreadsheet updates all the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top