| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Fillter data and copy to other table
I have a column, which i would like to filter and copy the filtered
data to other sheet. The filter criteria should be the items in the same column. Like using the auto filter. I know how to apply Auto filter - Selection.AutoFilter Field:=1, Criteria1:="xyz", but how to get this "xyz" from the values in that column? Should I loop throght the column cells, and somehow filter the items? I am lost? Also when looping throught column, how to stop if cell is empty? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto copy data from another database | Excel Worksheet Functions | |||
| Auto copy of data to first available cell | Excel Discussion (Misc queries) | |||
| auto copy old data to new cell | New Users to Excel | |||
| Auto copy data from 1 sheet into another | Excel Discussion (Misc queries) | |||
| Copy auto filtered data | Excel Discussion (Misc queries) | |||
Threaded Mode
