| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AUTO FILTER WITH VALUE IN CELLS AND COPY FILTERED DATA TO NEW FILE
HI
CODE IN FOR AUTO FILTER & COPY TO NEW FILE ' FOR FIELD 2 "TPT" IS IN RANGE("B2").VALUE ' FOR FIELD 3 "WEST" IS IN RANGE("C2").VALUE ' FOR FIELD 4 "AURANGABAD BRANCH" IS IN RANGE("D2").VALUE 'Selection.AutoFilter Field:=2, Criteria1:="TPT" 'Selection.AutoFilter Field:=3, Criteria1:="WEST" 'Selection.AutoFilter Field:=4, Criteria1:="AURANGABAD BRANCH" ' WANT TO SAVE OUTFILE XLS AS AURANGABAD.XLS ANY HELP URGENT. PLEASE |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you apply the auto filter to data that are filtered? | Excel Worksheet Functions | |||
| using auto filter, how to tell what columns are filtered? | Excel Discussion (Misc queries) | |||
| Copy visible cells on Filtered data | Excel Discussion (Misc queries) | |||
| Copy Auto-filtered data to new sheets | Excel Programming | |||
| Copy auto filtered data | Excel Discussion (Misc queries) | |||
Threaded Mode
