1. J

    Multi filter by word on Excel 2016 document

    Hi, This is my first post please be nice. I am creating a Windows 10 Excel 2016 document which takes a bulk data download on Tab 1 (5 rows, 70,000+ column entries), filters out around 10 words, filters in around 15 words (Keywords are Tab 2) and displays the filtered data (Tab 3) as 5 columns...
  2. U

    VBA: Filter that contains with multiple criteria

    Hi Gurus, I have below sample raw data. I need to filter and move the information that contains certain words. Example I need to Copy the whole row that contains "Missed", "Chck", "Note"& "Check" (might add more) in the Subject Column. Account Subject Number x Note 1 Note 2 Note 3 001...
  3. J

    VBA - filtering columns after inserting or deleting cells

    Good afternoon I'm looking for a way to make the field of an autofilter dynamic - for example: Range("a1:J" & LRow ).autofilter Field:=7, Criteria1:="" If someone were to add a column between B&C, the field would now need to be 8, but the code won't register this. I've thought about maybe...
  4. T

    Filter loop through macro

    I have various workbooks that I need to check the data in by filtering on various columns to find those that need to be checked and then I filter through the resultant list using usually column 'C', checking line by line and marking those 'done'. What I'd like to achieve is a button that...
  5. N

    Use only visible rows in Macros code after autofilter

    Hi, I have coded for a solver problem in macros. But the problem is the range in B column is auto filtered and the other rows are hidden. So as per inputs, only the rows in B column that satisfy the input are shown. It can start at any row. How do I include the code to use only visible cells in...
  6. J

    Find closest values

    Hi, I'm new to macros and can't find a good starting point for my problem. I want to loop through a row in a table looking for the 3 closest numbers (column D) to a value in a given cell (N5) and set the corresponding row to "yes" in column B. So if the 3 closest values is found in D3, D6 and...
  7. T

    Excel date vba filter

    Hi guys, Been stuck on this for days now so I'm resorting to asking for assistance on this one. I'm trying to filter between two dates in dd/mm/yyyy format ( my PC is formatted this way too in regional settings), but after I run the code, the date "custom filter" has mixed up the days and...
  8. R

    Keyword Search and Select Macro?

    First off, I'm open to a variety of solutions for this situation. I'm currently working on using excel to make a searchable database of documents. I'm hyperlinking the articles, and have some advanced filter settings right now. I'm making a column that contains keywords that relate to the...
  9. T

    Open de File with a sheet filtered according to a matriz

    Hello specialists, I have a sheet called "Data", and there from row 4 and along, I have several collunms with data, like "Main Responsible" in AO, "Country" in AK and "SBU" in AL; I am also have another sheet called "AuthUsers", where I've created the below matriz; soo, I am looking for a VBA...
  10. M

    Exclude the only one value and delete all values in vba excel

    When i apply filter , it should uncheck only John and apply filter to all the values except john and delete the rows till last value Mark Name 80 John 20 Maya 30 John 40 Peter In my report , John is the standard person. But Names daily will get change. I need to delete the rows...
  11. A

    Filter Inside Pivot table data values

    Hello, @MARK858 - Is it possible for you to help me on this please. I have a Pivot table, where i need to Select Blank Column next to last row of Pivot table and Put Filter. I tried some coding but i am getting an error. Please help to rectify. Steps: 1. select Row from a Blank Column (Here it...
  12. E

    Sort from Z-A with condition

    Hi, I would like to sort the "Location" from Z-A for each order . The label "item" goes with the Location, they are pairs. Here is an example of what I want to do: ABCDEFG1OrdersitemLocationOrdersitemLocation21367-66-400112761367-66-4001127831311-12-141111191367-66-4001127641311-12-14111033...
  13. A

    autofilter for dates by xlfiltervalues

    does any one know a location for the excel function by @Jon von der Heyden which displays AutoFilter criteria (including the date filter) in an Excel sheet
  14. A

    VBA - Concatenated data in one cell; delete entire row when 1 piece of info is not present

    I run a report that displays a list of employees with all the information associated with their employment record. One of the things on there is a concatenated list of all their Employee Roles, with a Valid To and From date. For example, if the list of possible Roles is as follows: Role 1 Role...
  15. D

    Run VBA from double clicking a cell

    Is it possible to run a macro subroutine when double clicking on a cell contained in a worksheet? what im thinking of is creating a subroutine that will filter data on a sheet and when the user double-clicks say "Cell A10" then macro would run if they double-click "Cell A11" a different macro...
  16. Mister_J

    Macro To Filter Column Based On What I Want To Remain Visible

    I’ve been looking into finding or creating a macro that can filter a column of categories that continuously grows. I always want to filter the same categories but when new ones are added I have to add the new ones to the list to be filtered out. So can I create a macro that will filter...
  17. B

    Issue with Excel VBA filter when no records

    Dear MrExcel users, I have a pivot table that extracts data from ms sql database and afterthat, I filter the data with VBA according to some criteria. Sometimes, the filter gives a run-time error '1004' because a criteria doesn't have any data to display. So I wondered, is there a solution...
  18. E

    Massive Pivot Table filtering

    I have a pivot table that is reading thousands of records. The pivot has three filters, one of which is the amount of time since yada yada yada. I want it only to show things within the past 5 days, but I don't want to manually click through the filter for a thousand different possibilities...
  19. F

    Filter Dates Stored In An Array

    Hi, I have a simple worksheet which has many dates in an column and I want to filter only Sundays from them. This is a very easy task if you can add a column in data but you cant. So as far as I know it can be done if you store all these dates in an Array in VBA and then filter that column with...
  20. S

    Search function looking for value in multiple columns and filtering

    Hi, I have this Excel sheet where I have my training exercises and I want to aply a search function since they are becoming many now. I have the muscle the exersice activates in column A and B and C since there are normaly multiple muscels activated. (In Swedish at picture, Muskel 1 and 2 and...

Some videos you may like

This Week's Hot Topics