Thread
:
Look up I think
View Single Post
#
5
Posted to microsoft.public.excel.misc
pdberger
external usenet poster
Posts: 258
Look up I think
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?
Reply With Quote
pdberger
View Public Profile
Find all posts by pdberger