Ive been having some errors with this part of my code in bold.
as i have this code run for 4 different sheets, each sheet will come back with different data, some sheets even with no data.
this code works fine on 1 sheet, and the rest keeps getting stuck at the bolded part even though...
<code>Hi gang - I need some help.....I'm doing an autofilter and want I want is that if the filter doesn't come up with any results, then I want to unfilter. If it does come up with a result, I want to copy the data in column H onto a different sheet.
What currently happens with my below code...
I need to update the following code that I haphazardly mashed together from several sources on the Internet to be a bit more flexible if rows from the 12M file are added or removed. I also require the code to be able to find the first empty row in the Report file as I have eight of...
I have recorded the following macro
Sub Macro1() Cells.Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
Range("$A$1:$C$500").AutoFilter Field:=3, Criteria1:="="...
I used these codes to filter out two values. How do I write code to filter out more than two values ?
Range("$A$1:$Z$100000").AutoFilter Field:=3, Criteria1:="<>Ciclo", Criteria2:="<>FROM", Operator:=xlAnd
I'm currently new in recording basic macro. Can someone help me get the unique values for in the account column and create each account a separate worksheet?
What I currently have is just for 3 items to filter the account columns for each items, copy the contents, create worksheet for...