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...
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...
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...
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...
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...
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...
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...
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...
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
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...
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...
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.
If I filter by Room 2, I will see Designer...
have this code for filtering but I am getting this error:
invalid use of Me keyword,
Private Sub ReapplyFilter()
Application.EnableEvents = False
.AutoFilter Field:=4, Criteria1:="r", Operator:=xlAnd
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?
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...
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
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...
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...
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
Dim Lastrow As Long
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...