Z
Zippy.01
I've got a SAC I'm doing for school and I'm stuck.
I'll tey explain it best I can. This is the task:
THE CLARKE FAMILY HAVE ASKED IF THIS WEEK'S ROSTER CAN BE CHANGED T
ALLOW KATE TO BE RELEASED FROM HER DUTY, AS SHE ISS ILL. PREPARE
SHORT LIST THAT INCLUDES SUITABLE MEMBERS WHO ARE AVAILABLE FROM TH
CLARKE AND ONE OTHER FAMILY
OK each family has an ID code and there are other restrictions such a
the other person must be female and the replacement must be a
emergency but that's not really to important.
Anyway the problem is the report must be on only *one* worksheet. Ho
am I meant to use filters to find the other person? Cos I need to us
the filter in the family ID column which returns results for member
from the Clarke family but then since the filter has been used I can'
find the other member... I'm not sure how to use advanced filters
Would this help?
Hopefully someone can make some sense out of that and help me out
I'll tey explain it best I can. This is the task:
THE CLARKE FAMILY HAVE ASKED IF THIS WEEK'S ROSTER CAN BE CHANGED T
ALLOW KATE TO BE RELEASED FROM HER DUTY, AS SHE ISS ILL. PREPARE
SHORT LIST THAT INCLUDES SUITABLE MEMBERS WHO ARE AVAILABLE FROM TH
CLARKE AND ONE OTHER FAMILY
OK each family has an ID code and there are other restrictions such a
the other person must be female and the replacement must be a
emergency but that's not really to important.
Anyway the problem is the report must be on only *one* worksheet. Ho
am I meant to use filters to find the other person? Cos I need to us
the filter in the family ID column which returns results for member
from the Clarke family but then since the filter has been used I can'
find the other member... I'm not sure how to use advanced filters
Would this help?
Hopefully someone can make some sense out of that and help me out