I have created a workbook for a preschool with one master sheet and all
others (classes) feeding from this one. What I need to do is create a
logic statement on one of my worksheets that creates an 'allergy list'.
It would need to generate a list based on the answer to one of the
columns in my master sheet.

For example: if (the particular cell in mastersheet says 'no') then do
nothing. However, if (the particular cell in mastersheet says
'anything but no' then:

Enter what it states in that cell here (example would be 'peanuts' or
'latex' or 'aspirin'), and in the subsequent cell enter the first name
of the student, in following cell enter last name of student and in
nextl cell enter the class the student is in, and in final cell enter
phone number of parent.

This worksheet would then have a master sheet of all children w/
allergies, what they're allergic to and their parent's tel number.

I haven't used exel in a while and am dumbfounded.

Any help would be appreciated.

How is the data organised i.e where are (sheet/columns) for allergy, student
names, class & parent contact number: use of VLOOKUP is most likely candidate.

"bettinab" wrote:

I have created a workbook for a preschool with one master sheet and all
others (classes) feeding from this one. What I need to do is create a
logic statement on one of my worksheets that creates an 'allergy list'.
It would need to generate a list based on the answer to one of the
columns in my master sheet.

For example: if (the particular cell in mastersheet says 'no') then do
nothing. However, if (the particular cell in mastersheet says
'anything but no' then:

Enter what it states in that cell here (example would be 'peanuts' or
'latex' or 'aspirin'), and in the subsequent cell enter the first name
of the student, in following cell enter last name of student and in
nextl cell enter the class the student is in, and in final cell enter
phone number of parent.

This worksheet would then have a master sheet of all children w/
allergies, what they're allergic to and their parent's tel number.

I haven't used exel in a while and am dumbfounded.

Any help would be appreciated.

This is all in one workbook that has some ten odd worksheets.

The first sheet in the workbook contains all student names, and then
has columns to indicate other info (DOB, days attending, lunch or not,
parent's phone number, allergies, etc.). On other worksheets I have
the classes pulling from that main one (i.e. Dancing Dinos, Cool Cats,
etc - remember, this is preschool). The last sheet in the workbook I
would like to have the allergy list generating so that all teachers can
have a comprehensive list of which of the ninety odd students are
allergic to something.
I may have to organize it differently, but I'm not familiar with the
VLOOKUP function.

Any help you can provide would be much appreciated. I'm actually
volunteering to do this list since the director is storing all of this
data on tens of MS Word documents and it's a nightmare for her to find
something. Of course now I have gotten stuck as well...

Thanks again,

Bettina


Toppers wrote:
How is the data organised i.e where are (sheet/columns) for allergy, student
names, class & parent contact number: use of VLOOKUP is most likely candidate.

"bettinab" wrote:

I have created a workbook for a preschool with one master sheet and all
others (classes) feeding from this one. What I need to do is create a
logic statement on one of my worksheets that creates an 'allergy list'.
It would need to generate a list based on the answer to one of the
columns in my master sheet.

For example: if (the particular cell in mastersheet says 'no') then do
nothing. However, if (the particular cell in mastersheet says
'anything but no' then:

Enter what it states in that cell here (example would be 'peanuts' or
'latex' or 'aspirin'), and in the subsequent cell enter the first name
of the student, in following cell enter last name of student and in
nextl cell enter the class the student is in, and in final cell enter
phone number of parent.

This worksheet would then have a master sheet of all children w/
allergies, what they're allergic to and their parent's tel number.

I haven't used exel in a while and am dumbfounded.

Any help would be appreciated.