Hoopsah
10-22-2008, 04:45 AM
Hi
I have a list of absentees and would like to create a list showing all the episodes they have been off.
I have created a sheet that has a couple of drop downs that hopefully when populated I would be able to list all data for said person.
I've attached a copy of what I am working on as well as a tab "What I would Like To See" which is the way I would want it to show the details and all details come from the tab "Absence_Worksheet".
I have tried Lookup's but can only ever find the first record on the list and not all the details,
Hope I've explained that ok.
I have a list of absentees and would like to create a list showing all the episodes they have been off.
I have created a sheet that has a couple of drop downs that hopefully when populated I would be able to list all data for said person.
I've attached a copy of what I am working on as well as a tab "What I would Like To See" which is the way I would want it to show the details and all details come from the tab "Absence_Worksheet".
I have tried Lookup's but can only ever find the first record on the list and not all the details,
Hope I've explained that ok.