newk
05-10-2005, 02:27 AM
(Please refer to the attached spreadsheet)
On worksheet ?Test Matrix? at the top I have a drop down box with 3 options; ?ABL, Factoring & ID?.
When an option is selected it looks up worksheet ?All tests? and displays the tests required.
However the output is displayed out of order and ?Factoring & ID? options leave unwanted gaps in between the tests.
I would like to be able to sort the tests on worksheet, 'test matrix' by column C and remove any unwanted gaps.
I have tried macros but to no avail. Please could someone help me!
On worksheet ?Test Matrix? at the top I have a drop down box with 3 options; ?ABL, Factoring & ID?.
When an option is selected it looks up worksheet ?All tests? and displays the tests required.
However the output is displayed out of order and ?Factoring & ID? options leave unwanted gaps in between the tests.
I would like to be able to sort the tests on worksheet, 'test matrix' by column C and remove any unwanted gaps.
I have tried macros but to no avail. Please could someone help me!