Why a separate tab when you can just use ONE col with 1 2 or 3 and then
Dataautofilterfilter on the helper column for 2.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"fatdave" wrote in message
...
I have got a list of people, First name, Surname, Tel Number and a small
note. Each of these people are members of groups. In columns E - G I can
put
a Y or a 1, witch ever is easier. Each group has it own tab. What I would
like to happen is: - when I put someone on the mater list and add them to
one
or more groups in that then will also be on the group tab, with out any
extra
input from myself.

I have a list with

Column A Surname
Column B First Name
Column C Tel Number
Column D Note
Column E Group 1
Column F Group 2
Column G Group 3


Any ideas?