Consolidating sheets in Excel
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
|