T
tgcali
Hello,
I have a workbook with 250 sheets plus a summary sheet. In cell B2 on every
sheet is an ID number that is either 6 or 8 digits long. I need to know if I
can generate a list of which ID numbers (which sheets) meet a specific
criteria.
For example; the summary sheet shows there are: 24 MID-LEVEL MALE
TERMINATED. How do I find out which 24 males are mid-level and terminated? It
looks like this on the summary:
MID-LEVEL
TERMINATED: MALE 24
FEMALE 9
If this is possible, I would need to be able to determine which sheets apply
for any number of combinations: male/female, mid-level/level 1,
active/graduated/terminated/pregnant.
I've gotten a lot of great help from this site with the formulas, etc. I
needed to set up this workbook. Now I'm being asked to show which people
represent each total listed on the summary page if needed. I need a list of
the ID numbers instead of names for confidentiality purposes.
Thanks in advance for any tips, advice or help you may have.
tgcali
I have a workbook with 250 sheets plus a summary sheet. In cell B2 on every
sheet is an ID number that is either 6 or 8 digits long. I need to know if I
can generate a list of which ID numbers (which sheets) meet a specific
criteria.
For example; the summary sheet shows there are: 24 MID-LEVEL MALE
TERMINATED. How do I find out which 24 males are mid-level and terminated? It
looks like this on the summary:
MID-LEVEL
TERMINATED: MALE 24
FEMALE 9
If this is possible, I would need to be able to determine which sheets apply
for any number of combinations: male/female, mid-level/level 1,
active/graduated/terminated/pregnant.
I've gotten a lot of great help from this site with the formulas, etc. I
needed to set up this workbook. Now I'm being asked to show which people
represent each total listed on the summary page if needed. I need a list of
the ID numbers instead of names for confidentiality purposes.
Thanks in advance for any tips, advice or help you may have.
tgcali