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?