filtering

  1. K

    Filtering based on input in listbox

    Hello all, I need help with the following macro please. I am trying to use a userform to allow a selection of criteria. Based on the selection a column in the excel sheet should be filtered. So far this is my code: Dim Ary2 As Variant Dim i2 As Long, j2 As Long With Me.ListBox2...
  2. K

    Filtering column for input in ListBox

    Hello everyone. I have a document with a userform that allows users to select a specific area in a list box. Multiple selections are possible. Based on the input I would like to filter column E called "AreaColumn" for the input made by a user when cofirming the user form with OK. So far I've...
  3. L

    VBA - Find and filter last column

    Good afternoon and a happy new year! I'm creating a macro that will look for the column and filter... the only problem is, there could be 14 columns one run and there could be 12 the next (it could range from more or less), but it'll always be in the last column... but when I create the code...
  4. F

    Issue with Filtering

    Hello forum, Basically I have a questionnaire (Button) that allows me to filter the room and it shows everyone in the room. Is there a way that once I filter the room and then filter the people in the room without loosing the room filter. Example: If I filter by Room 2, I will see Designer...
  5. J

    AutoFilter

    Hi, have this code for filtering but I am getting this error: invalid use of Me keyword, Private Sub ReapplyFilter() Application.EnableEvents = False With Me.[a1] .AutoFilter .AutoFilter Field:=4, Criteria1:="r", Operator:=xlAnd End With...
  6. B

    VBA Autoprotect sheet and allow filtering

    Hi, I have created a macro that will autoprotect and sutosave a sheet when closing with a specific password. How I need to allow people who do not know the password to filter on the sheet. what code do I need to add to allow filtering without being able to unprotect the sheet? Code I...
  7. B

    how to see if there's any unique values

    I've got data like this below. All the weights are supposed to be consistent. So for example all 3 pound weights are supposed to be $5, regardless of province. But there could be an error somewhere, such as in the last line. Is there a way to simply find all the difference prices for each...
  8. J

    Filtering a Pivot by user input value?

    Hi, I have a pivot table with the left column numbers 1-100 And I want to be able to filter between 2 numbers (from user inputboxs for min and max) Eg. Numbers 11-20 or 1-80 Unsure how to do this, Any help appreciated
  9. R

    No idea how to title...Sorting in Excel to include group header?

    Hi! I'm not sure how to phrase my question which makes hard to search for an answer....Can I sort by a grouping under a heading? I have a sheet that I want to filter (by person), but I want the subheadings (Project name) to be included with the filtering. I can only explain by pictures...
  10. B

    Advanced Filtering

    Referencing the image below, I created the following filtering criteria within Advanced Filtering in order to filter my Data Set. Within the Advance Filter entry window, when I set my criteria range to filter based on the date criteria only the advance filtering works just fine. However...
  11. R

    Copying values millions of times

    Hello all, I have problems using the code below. It does the work filtering and getting the right columns however it copies the same columns millions of times up to row 1048576 Could you please help me?. Many thanks. Rose Sub Filtering() Dim Lastrow As Long With Sheets("Sheet1") If...
  12. M

    xlsm workbooks much slower than xls workbooks

    Can anyone explain why I find it so much faster to run my workbooks created in Excel 365 in Excel 2003 compatibilty mode? Even with some complicated and very long VBA macros including colour sorting and also using Data Advanced Filtering I have not found anything that I use that will not work...
  13. D

    vba get the # of rows used after filtering data from a certain point

    hi, after filtering...i want to count the number of rows used from after the headers...the headers fill in the top 6 rows and the data is row 7 and below (from columns A to N)....essentially i just want vba to tell me how many rows are used today after doing some sort of filtering and excluding...
  14. A

    Auto Filter

    Hi, Expert I am new in a Excel. I went to get you expert solution for creating a VBA code for Auto Filtering System. How Can I do it. Thanks in advanced.
  15. L

    Filtering results into array

    Hello guys, im trying to filter some data and add it into an array My filtering code is: If Sheets(sheetName).AutoFilterMode Then Sheets(sheetName).AutoFilter.ShowAllData lastCol = Cells(1, Columns.Count).End(xlToLeft).Column lastRow = Cells(Rows.Count...
  16. M

    VBA Filter Table based on Cell Value on Another Sheet

    Hi, I've hunted around for code for my problem and thought this would work but doesn't. I have a table where I want to filter 'Country Name' = to 'Country' value listed on another sheet. (Then, copy the data from that table to other cells. - which I think I have worked out) Option Explicit...
  17. A

    Hyperlink in PPT opens an Excel File AutoFilterd

    Hi Guys, I wonder if there is any possibility, to use a hyper link from PPT to an EXCEL file. Once the Excel file is opened, the immediate action will be Auto Filtering to the exact value that i have clicked on hyper link. For example: the Hyper link value is: 'Diagnostic' - opens a linked...
  18. R

    Automatic sheet layout based on topic selection.

    The idea is to have a topic selection page where i can select yes or no and then based on my answers the next sheet will show all of the topics that i answers yes to. Images can be seen here: https://ibb.co/YfKK6pG AND https://ibb.co/1GpyjmJ Looking it this it maybe could be something where...
  19. D

    Filtering Pivot Table to fill non-formatted cells with color.

    Hi All, I am sure that this is an easy fix for those that know what they are doing (unlike me). I have a background color surrounding a pivot table in Excel, but when I filter out column entries, this leaves blank non-formatted cells in the pivot from the filtering. What I am wanting to do is...
  20. T

    Power BI in Excel

    Hi, I am a bit stick trying to replicate the work of my former colleague at work. Some time ago he create a Power BI visualisation of annual costs with a lot of simple filtering options (departments, sub-departments,...). Recreating that in Power BI is no problem, but he somehow made the output...

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