Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do i use a filter or a macro?
I have a list of 7400 ppl where some of them have similar member numbers.
col A has "Not Found" for members who are to be moved to another worksheet. other members who need to be moved have member numbers (column B) similar to the "not found" members yet do not have "not found" in col A Is there a way i can filter "not found" in column A and for all visible member numbers. see also all filtered-out similar member numbers. there after i need to move out these rows to a different worksheet but if am able to filter it th way i want that would be easy. othewise i need a macro that sees "not found" in column A, reads the member number from column B and looks for all similar numbers in column B and moves all data that fits these criteria to sheet1 . thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do i use a filter or a macro?
Take a look at Data Filter Autofilter......then make selections from the
arrows at the top of your interested columns.........to revert all back to normal, just do data Filter Autofilter again....it's a toggle....... hth Vaya con Dios, Chuck, CABGx3 "anthony" wrote in message ... I have a list of 7400 ppl where some of them have similar member numbers. col A has "Not Found" for members who are to be moved to another worksheet. other members who need to be moved have member numbers (column B) similar to the "not found" members yet do not have "not found" in col A Is there a way i can filter "not found" in column A and for all visible member numbers. see also all filtered-out similar member numbers. there after i need to move out these rows to a different worksheet but if am able to filter it th way i want that would be easy. othewise i need a macro that sees "not found" in column A, reads the member number from column B and looks for all similar numbers in column B and moves all data that fits these criteria to sheet1 . thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do i use a filter or a macro?
looks like u didnt understand my qtion.
A B C D not found james jones 0112 john doe 0112 JEAB DOE 0112 I need a macro that sees "not found" in the first column, reads the member number from column d, and cuts from that worksheet all rows having that member number and move them to another worksheet. i guess only macros can work for this. thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto filter within a macro | Excel Discussion (Misc queries) | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
link to combobox | Excel Discussion (Misc queries) | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) |