auto filter

  1. B

    1004 Error when using an array for auto-filter criteria

    Hello to all, I'm getting a 1004 error when trying to apply a autofilter using a array. Bellow is the line of code in question: Worksheets(CONBaselineSheet).Range("A1:" & GetColumnLetter(CONLastTaskColumn) & GBLProjectFile.TotalTasks + 1).AutoFilter Field:=varField.Field...
  2. A

    Issue: Blank fields are being copied

    Hi, I am using the following code to copy paste information from one worksheet to other. It is supposed to filter for non-blanks in a column and copy over a range of other columns including the column that was looked up to another worksheet in certain cells (skipping 1 row and 26 columns or i.e...
  3. J

    Need Help with Filter

    Hi, I need help with auto filter in excel 2010 , I have attached the sample file, Need t apply filter in Sheet Name ( SAP Dump ) Coulm N for value <0 and after that I have filter Coulm H in same sheet with value present in another sheet named User name , If colum H is matching with value in...
  4. D

    Using Auto Filter with a barcode scanner in an inventory database

    Hi All, I'm building a simple inventory database in Excel and I'm stuck on the last feature I need to add. I would like to be able to scan a barcode and eliminate all database entries except the values in the line that I scanned, just as if I used the autofilter drop down arrow and entered a...
  5. M

    Pivot Auto Filter by Cell Text Value

    Hi! I wish to filter a Pivot based on the Value in Defined Cell. I am not aware of VB Code. Tried to Copy a Code online but not working. Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Set rng=Me.Range("F1") If Not Application.Intersect(Target, rng) Is Nothing Then...
  6. M

    Macro allowing user input to auto filter on pivot table

    Hello all. I have scratching beneath the surface of Excel for a little while now, but I'm finally stumped and hope to find some help here from someone with a little more knowledge... I am trying to write a macro that prompts the user to change the date range in a pivot table report. My current...
  7. U

    Auto Filter by cell value

    Dear All, I need a auto filter vba code that filtered the data by cell value. Like I have a list Head Office, Regional Office and Zonal Office in cell F2. and C column have these values to be filtered according to F2 Cell Value. if you peeps attached a specimen file will be helpful for...
  8. W

    Project Labour Sheet - Query text and return corresponding results

    http://onedrive.live.com/redir?resid=C793CA7C52E2A4A2%21105 Hello, Hoping someone can help with this. I have the attached Labour/Time entry for a project I'm managing. What I would like to do is query a users surname via an entry field and for every row it finds I would like to return the...
  9. A

    Auto Filter Help

    Hi, I am new to VBA. My task is to write a macro on auto filtering and it has troubled me for days. I got 2 columns of relevant data. Cells in column A show the team name and corresponding cell in column C shows the person who belongs to the team. For clear illustration, this is an example of...
  10. I

    Macro to AutoFilter create PDF/Mail and copy selected data to Template Excel file

    Hi I really need expert help in this project. I already made a part of my project working. I have an excel file with client data and tracking of missed service. We send report per client, so I put a field with a drop down list with all our client name plus a field for date. We enter all our data...
  11. J

    Using VBA to filte where criteria is variable

    Hello again, I am attempting to filter a file using VBA and the criteria will vary each time the macro is run. Also once filtered I will need to select the filtered cells and delete the rows, of course the range will vary depending on the filter criteria. Is there a way to write code for this...
  12. D

    Macro that uses "does not contain" to autofilter OUT a cells value

    Hi All Iv'e searched extensively and can't seem to find how to do this. I know how to filter based on cell value, and how to auto filter "does not contain", but is it possible to combine these? i.e. Filter OUT the value of a cell from a range? Appreciate your help in advance.
  13. A

    Extracting table from data within Excel using VBA

    Hello everyone, I have some data, in a xlVeryHidden sheet, with multiple headers. An example is given below. I would like to auto-generate a table on a different sheet with only revelent headers and filter by source and month/year. Basically, I want to write a macro that would make this table...
  14. S

    Conditional formatting moves with autofilter

    Good afternoon, I have a spread sheet where I am looking at using a traffic light system dependant on the value of the cell. I have 3 different thresholds for 3 different sizes: Small: in-between 1 - 4 (Green) in-between 5 - 12 (Yellow) greater than 13 (Red) Medium: in-between 1 - 8 (Green)...
  15. C

    Help Needed with Drop Down Box in Excel 2010

    Here is the outcome I am seeking: I have a dropdown box that is generated from a separate worksheet, however that contains a list of 2000 so options to select. What I want to happen is when I start to type in the drop down box, lets say "Consultant" then all fields within the drop down box list...
  16. B

    Creating an autofilter...

    Hi there, I am trying to create an autofilter for a table of values to only display entries that correspond to "N" in a specific column. Out of all the entries within the table I require only the ones that correspond to "N" in a specific column (as you would with the standard autofilter within...
  17. A

    Refresh the data based on a Command Button click to Auto Filter, Copy from a File/Worksheet stored at a particular location & Replace while Pasting in

    Hi All, Request your help in defining a macro for a command button which helps me to Autofilter and Copy from a SourceData file (w/o opening) which is stored at a location in d-drive and while pasting into another sheet (master file will have the sheets which are already created for the...
  18. A

    Command Button Macro to Auto Filter, Copy from a File/Worksheet stored at a particular location & Replace while Pasting into another worksheet upon re

    Hi All, Request your help in defining a macro for a command button which helps me to Autofilter and Copy from a SourceData file (w/o opening) which is stored at a location in d-drive and while pasting into another sheet (master file will have the sheets which are already created for the...
  19. S

    Macro for Auto Filter to hide on some columns

    Hi can anyone please help me with a macro code please I want to hide auto filter on the following columns A,B,C,F,G,N,M,AB,AD But want to show in all other columns How can i do this? been trying all day and i bet it is simple lol i am using excel 2003 :confused:
  20. H

    Dynamic autofilter selection by using Vba

    Hi Team, I would like to select auto filter with dynamic content text (this will change every time but same column). This is required to integrate into in my main macro, if you can give input box where I can input the required content to filter and same should get filter in the sheet. The...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top