I want to produce a workbook-based report that others can use to populate a
list of risks. I have up to 30 rows of data in 10 columns in a risk databank.
Each row describes a risk and associated management data. I would like to be
able to produce a subset list of risks for a new report for a particular
activity by selecting specific rows from the databank. The subset list should
occupy consecutive rows without gaps. I would need to be able to extend the
databank as new risks are identified.
A simple method of selection is required, e.g. ticks in checkboxes.
Some way of sorting the resulting list might be helpful, e.g. to put most
severe risks first.
Can this be done in Excel 2003? It's possible to use AutoFilter but setting
and adapting custom filters is fiddly and beyond the experience of many who
will be using this.
Any suggestions will be gratefully received.
--
Richard

Search the web and raise money for charity at www.everyclick.com