This is so I can export eatch tab as a CSV file and inport it in to a sms list.

"pdberger" wrote:

OK -- why do you need them on separate tabs? Are you using this for data for
a Word mailmerge or something?

"fatdave" wrote:

I need more that one column becouse thay can be in more than one group.

"Don Guillett" wrote:


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?