hi
I recorded 3 macros so I could see the code for each and hopefully compile something which will filter for all 3, as the standard Excel filter will only allow for 2.
I am trying to filter to only leave rows with a zero, a blank or that are >=30
The code for code for each came up as...
I have numeric values in another sheet by the name of summary.
If cell value in summary sheet example F5 is > 0 or less then 0 or <> 0 only then i want to run the macro for that
particular company .
The problem is if i use if condition it stop running the second macro if the first value is...
Hi all,
I've got a macro which appeared to be working perfectly, however when I ran the data without any of the products to be excluded I found that I was losing EVERYTHING :confused: I've narrowed the culprit down to this:
'Remove excluded products Sheets("Consolidated").Select...
:)
Hi all,
I have the following code which will filter the columns as per my requirement but after filtering the columns i need to name the active cells as "Ship" in the column "Remarks" based on the used range column A. Please assist.
<code style="margin: 0px; padding: 0px; font-style...
Hi there
I have done a macro that filters the whole worksheet. Then I did another macro that unfilters it.
The code "Selection.Autofilter" Unfilters the worksheet. But I want to get rid of those pesky dropdown arrows every time I run the code. I tried the following code, but I got an error...
Hi Guys,
Is there a way to delete all the rows int he selected autofilter in the below code. At the moment it only looks as rows 2:29.
Thanks
Sub Macro1()
ActiveSheet.ListObjects("Brecon_Mail_Merge").Range.AutoFilter Field:=12, _
Criteria1:="Non Ford"
Rows("2:29").Select...
Hi Guys,
I have a list of data with a persons name in column N. For each person i have created a tab which is identical to their name in column N. Is there a way to filter by that person and copy all of the data to the relevant named tab as values. At the moment i am doing the below but...
I have been growing more and more comfortable with Excel in my new position and really enjoy learning how to work more efficiently with it. Recently I have been filling in for someone on long term disability and I have to extract data from AVANTIS to an existing Macro every week that we use to...
Hi Guys -
I have this code. The 2nd part fails (Doesn't move to EFCFilter on error) whenever there is no matching filter criteria in 1st part. But, runs perfectly if there is matching filter criteria found in 1st part. Any thought?
'--------------------------1st...
I have created a spreadsheet that pulls all data as required but when the code runs to Macro3, it gets hung up and will not paste into my sheet. If someone can tell me what I could use to make this work for a paste of the tab named what is in cell N16, I would appreciate it...
The process runs...
For the following script, I have one issue where I need to ask the user for the month in cell N16 as there is no logical way to figure out the correct tab without user input.
So for the line in Macro 3 listed as Worksheets("July 2018").Activate, I need assistance on pulling the Worksheet name...
Hi All,
Can you please help me by adjusting this VBA for autofill until empty for the following ranges?
ActiveSheet.Range("$B$1:$N$115326")
Selection.AutoFill Destination:=Range("A2:A115324")
Thank you very much!!!
P.S.
See VBA...
I have a simple module that calls a form to allow the user to select a row that sets a header filter and colors. I am trying to figure out how to convert this to vb.net or vb6 so it can be compiled.
All the documentation I found is from 2005 visual studio and it doesn't work in visual studio...
Hi can anyone help with replacing the lines in RED with the lines in Blue to multiple subs?
Sub dups1()
Sheets("Sheet11").Select
Dim Sheet11 As Worksheet: Set Sheet11 = Sheet11
Dim lRow As Long
lRow = Sheet11.Cells(Rows.Count, "A").End(xlUp).Row
Range("A1:BD" &...
I am trying to create dynamic macro if the data set does not contain the value Rizwan then copy paste it somewhere else , and then remove the data containing Rizwan from the source data . the height of data can vary and sequence is also not guranteed. how to make the macro dynamic i tried...
what have i done wrong the first time it run it errors the second time it works
Sub pitchers()
Cells.Select
Selection.AutoFilter
ActiveWorkbook.Worksheets("Sheet1").AutoFilter.Sort.SortFields.clear
ActiveWorkbook.Worksheets("Sheet1").AutoFilter.Sort.SortFields.Add Key:=Range _...
Hi friends,
I need a macro to auto filter and save the result as an image.
Would you please help me?
I found this code but it "prints" the result i need to save the result as an image.
Sub Auto_Print_Lamp_PK()
Dim noDupes As New Collection
Dim rw As Long
Dim itm As Variant...
This code searches for a criteria value catval between the given dates d1 & d2:
Range("A1:E1").Select
Selection.AutoFilter
With Sheets("REGISTER").Range("B1").CurrentRegion.Offset(1, 0)
.AutoFilter Field:=2, Criteria1:=catval
.AutoFilter Field:=3, Criteria1:=">=" & d1...
I am not very knowledgeable about macros but the company I have just started working for has a few it uses to make reports out of the system more useable quickly. However, there is one that is broken and seems far too complex for me to fix so I am trying to copy another macro to at least...
Hi All, I have been searching and changing this code and nothing has worked. I have been running the code after copying the formula as a work around. Can anyone explain what it is I am doing incorrectly. Ive tried the following:
Sub Key_Items_Validation1()
Sheets("ProductivityData MTD").Select...
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.