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

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 wrote:

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 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