1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. L

    Mirror column from another workbook that moves

    In one workbook, I have a column A which A1 contains "Cities". In another workbook there is a "Cities" column, however, it's not in a static position. Is there a formula that I can use to look across Row 1, find "Cities", and list all the not empty cells in that column on my local workbook...
  15. S

    VBA Autofilter

    Hi I have the following in VBA for my "Actuals" sheet in order to autofilter the data in that tab based on the period (1,2,3 etc.). Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range("A2").Address Then Range("a10:d500").CurrentRegion.AdvancedFilter...
  16. B

    Working out an average using multiple filters

    Hi, I am trying to work out the DAX to calculate the average time taken to fill a specific type of vacancy from my data source ‘CSD Archive’ To do this manually I would set filters on the following columns: ‘% Filled (Static)’ to 100 ‘Route’ to 1.GRS To work out the average I would then...
  17. A

    Filter for value, paste into a new sheet, and save down copy

    Hi everyone, been trying to solve this problem for a bit so hoping you can help :) I have a master workbook with 3 data tabs and 3 corresponding blank tabs. Each data tab has everyone's data by Name in the same column. I'd like to filter each of the 3 data tabs by Name, paste those values onto...
  18. B

    Pivot Table Filter On "Difference From"

    Hello, I cannot figure how to use a pivot table to filter a pivot table by the largest or smallest "difference from" the prior year. The use setting is to see only the top 10 growth or loss versus the previous year. My sample dataset is as follows: Year Region Amount 2020 1 100 2019 1 90...
  19. V

    Help Filtering Data

    Tossing this out to the Excel geniuses of the community. I need help creating a spreadsheet where I can associate an author’s statement to multiple keywords. I’ll have hundreds of individual statements with multiple keyword associations for each statement. I need to be able to search for those...
  20. K

    Filter two pivot tables in one sheet based on a cell value

    Hello, I'm trying to create a macro that will filter two different pivot tables in one sheet based on a value in cell A1 of the same sheet. I have some code earlier in this macro that's working fine, so I don't show it here. Below is what I've written to filter the first pivot table in the...

Some videos you may like

This Week's Hot Topics