Data Selection on second workshhet

[Justin]

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

 

[Dave Peterson]

I'd keep the data in one worksheet.

Then use data|filter|autofilter to see the info that I want.

But if you really, really must. Keep the data in one worksheet and refresh the
worksheets whenever you need (not while doing input--just run the macro when
you're ready).

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Justin]

I wanted to avoid the hassle of macro for security reasons (company's
AD-Policy, macro signing...)
But it really seems there's no database formula one could abuse for
that.

Thanks a lot!
Especially for the links!

Regards,
Justin