Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by value of cell
I am trying to filer a sheet by a value of a cell on a second sheet.
here is what I have going on. Sheet2 has employee vlaues for income and an id number associated with each. Sheet3 has a list of employee numbers and I need the employee number in Sheet3!$A2 as the sort cirteria. This would give me all the info on Sheet2 I need, then I need to replicate for the rest of the values on Sheet3 to get the correct info. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by value of cell
You could probably adapt this code to do what you describe:
http://www.rondebruin.nl/copy5.htm -- Regards, Tom Ogilvy "trward79" wrote: I am trying to filer a sheet by a value of a cell on a second sheet. here is what I have going on. Sheet2 has employee vlaues for income and an id number associated with each. Sheet3 has a list of employee numbers and I need the employee number in Sheet3!$A2 as the sort cirteria. This would give me all the info on Sheet2 I need, then I need to replicate for the rest of the values on Sheet3 to get the correct info. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adv Filter with Ref Cell | Excel Worksheet Functions | |||
filter by a date in a cell | Excel Discussion (Misc queries) | |||
Can I filter just one cell instead of the whole row? | Excel Discussion (Misc queries) | |||
Filter on cell value? | Excel Programming | |||
last cell in filter | Excel Programming |