Can you attach a sample copy of your workbook?
In sheet Student Analysis, I have a column (G8:G37) which looks up whether the cells I1:I33 (in Summary sheet) is lower than C4:C33 (in Master Sheet) and shows the value in A4:A33 (in Summary Sheet) if it is.
Essentially it looks up whether a students % mark is lower than their target, and shows their name if it is. If it is higher then it shows nothing ("").
Code I am using is:
What I want to do:Code:=IF(Summary!$I4<Master!$C4,Summary!$A4)
- Be able to select a topic (column in summary sheet)
- Show students with a mark lower than their target for that topic only
- I've created a list box in H2 which has the headings from the 'Summary' Sheet (I3:O3)
- I now need to filter (G8:G37) to only show the column based on the topic selected in H2.
Example, if Topic 3 is selected in the Student Analysis sheet, G8:G37 should show K4:K33 (from Summary sheet), if Topic 5 is selected G8:G37 should show M4:M33 (from Summary Sheet).
See if this works.
Orange column is where you need to test autoupdate of students based on list selection.If this works then you could just cut and paste over yellow cells and delete orange column.