Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Selection on second workshhet
Hi,
I've got the following Data on sheet 1 person, group john,A tiger,B Scott,C larry,B and so on now I want all memebers of group A to be displayd on sheet2, group B on sheet 3 etc. So when I add someone it is autmatically displayed on the rigth sheet. is there any matrix or array formula to accomplish this? thanks for any help regards, Justin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy Data selection from one workshhet into an existing worksheet | Excel Worksheet Functions | |||
Can I expand Excel workshhet beyond 65000 rows? | Excel Discussion (Misc queries) | |||
Password protect a workshhet on the net? | Excel Worksheet Functions | |||
workshhet variable | Excel Worksheet Functions | |||
How to pass a workshhet name as a parameter into a subroutine ? | Excel Discussion (Misc queries) |