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...
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...
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...
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)
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...
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...
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...