filtering

  1. F

    VBA | Filter Multiple Columns Based On Single Cell Value

    Hi all! I have a named range - "States" - that are column headers. I would like to filter the columns in this named range based state selection in another cell (F1). If the State selected in cell F1 equals a state in the Named Range, keep that column visible, but hide the other columns. I'm...
  2. S

    Advanced filtering of data into other sheet and copying the same sheet into a new workbook

    Hello ..!! This is my 3rd thread with Mr.Excel and my journey here is making me visualize what all can I automate using VBA and becoming successful with smaller macros for now. Thanks to everyone who is making my journey here fruitful ..!! :) So I am here with a request for macro that I need...
  3. V

    Pivot Tables - Excluding new items in manual filter

    Hello, I am having an issue with some pivot tables I have created that pull from a query. I have the field settings option for the product filter to NOT include new items in manual filter: Despite this, when a new item enters the dataset that the PT is pulling from, it is adding new products...
  4. M

    FILTER Function - Maintaining subheadings without #SPILL

    Hi, To begin with, I'm stuck using cell formulas due to Excel Online.... & I would ideally like this to be recalculated when formulas are recalculated. I'm looking to format my data below like it is under "Ideal output" I would like to avoid spill errors if I find more ID matches, and push...
  5. M

    Filtering from one table to the other

    I have two tables on two different tabs within a sheet. The first two columns are the same (company names and alias). One of the tables includes a lot of different filtering information such as the industry of a company. The other table contains information that's relevant to whoever is going to...
  6. E

    Keep a currently Filtered Visual while Filtering another Visual

    Hi all, I wonder what I am doing wrong or maybe I have missed something. When I filter on the 164 Due more than 3 Weeks the Within Timescale visual updates (brilliant). If I then select the 1 False the Visual updates as well the the one to the left (image below). This then has a knock on...
  7. L

    Issue in my macro

    Hello, I am using a macro filtering with a "X" in a certain column and pasting in on another table, I need to do it on repetitive way with different filtering column. It works until a certain column, then the macro is not going forward. I have first a macro defining a format for the subject...
  8. G

    Keep rows when filtering

    Good afternoon! I have an excel spreadsheet I'm making that lists about 8-900 companies. There are 12-3 columns with certain types of info (contact name, phone, company type, etc) They are organized by company type, so row 15 would say "Demolition Company" and then rows 16-40 will be the demo...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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
  17. 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...
  18. 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...
  19. 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...
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top