Hi All
I am looking to find values on a large data sheet and export to a report.
What I have is a training record with several NAMES and several COURSES (split into modules) each module is given a number of points. I would like to be able to select a name and display the persons weekest area. ie the three lowest scores.
I currently use VBA to access all areas of the form and run the dynamic reports, this involves referencing the name from a drop down and updating calculations to suit and importing photograph and putting all on one sheet.
It would also be good if you could do the same in reverse, as in select course and list all peop;le who have little or no points in that field.
Thanks All
I am looking to find values on a large data sheet and export to a report.
What I have is a training record with several NAMES and several COURSES (split into modules) each module is given a number of points. I would like to be able to select a name and display the persons weekest area. ie the three lowest scores.
I currently use VBA to access all areas of the form and run the dynamic reports, this involves referencing the name from a drop down and updating calculations to suit and importing photograph and putting all on one sheet.
It would also be good if you could do the same in reverse, as in select course and list all peop;le who have little or no points in that field.
Thanks All
