field=3

Hi all 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...

Hello, 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...

Hi Guys, I have recorded the following macro Sub Macro1() Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("C1").Select Range("$A$1:$C$500").AutoFilter Field:=3, Criteria1:="="...

Hi 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

Hi, 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...