On Jan 25, 2:21*pm, Don Guillett Excel MVP
wrote:
I would set it up as ONE sheet for all and use
DATAFILTERAUTOFILTERFILTER by type with a code or drop down
limiting the type entered in the TYPE

On Jan 25, 3:37*am, niallheavey wrote:

Hi all,

I am doing up a spreadsheet of members of a sports club.

The thing is though there are many different types of members -
Juvenile, Mens playing, ladies playing, social members, family members
etc.

Is it possible to have separate sheets for each of these member types
and then to have one main sheet of all members?

Obviously I can copy and paste when a new member is entered into one
of the "sub-sheets" but i'm guessing there is a way of setting it up
so that all new members entered on one of the member-type sheets
automatically enters in the main sheet?

Hopefully that makes sense.

Thanks in advance,

N

Ok,

I suppose it could work but not ideal!

I might set it up like that for now but if anyone else has any other
ideas please let me know!

Thanks for your help Don, looking like its my only way of doing
things!!