Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Thanks in advance The following code is set for Creteria1 to = "A" how do I make it for A, B or C With Worksheets("Panel Details").Range("A1:IV2500") .AutoFilter Field:=1, Criteria1:="A" .SpecialCells(xlCellTypeVisible).Copy _ Worksheets("SS A").Cells(1, 1) .AutoFilter End With Thanks again Trev |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Creteria Lookup(Between Dates) | Excel Worksheet Functions | |||
Sum data in a column if multi creteria met | Excel Worksheet Functions | |||
SUMIF with 2 creteria one Name one DAte | Excel Worksheet Functions | |||
How to use the IF function to resolved more than one creteria | Excel Worksheet Functions | |||
SUMIF with 2 creteria one Name one DAte | Excel Discussion (Misc queries) |