I would like to use our case details listed on a spreadsheet to allow staff to enter one or more criteria and have the details of all relevant cases show up on another tab. I have attached a sample of the type of information recorded. If possible, but not a requirement I would like to query the case number by year. Our case numbers are allocated by the last two characters indicating the year the case was accepted, so 301/18 was started in 2018,etc. So from the example provided, if the staff enter information on some of the fields, I would like all cases which match the criteria to appear beneath on the same tab. This has to be done without VBA, as our systems are restricted.
| Example Data Table.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 4 | Case Number | DATE Completed | Details of Case | Outcome | Case OFFICER | Area of Origin | Date Issued | ||
| 5 | numeric | date | text from drop down list | text from drop down list | text (names) from drop down list | text from drop down list | date | ||
| 6 | 301/18 | 20/11/2018 | Child Exploitation | Upheld | Mr Excel | England | 01/01/2019 | ||
| 7 | 157/19 | 01/10/2019 | Neighbourhood Complaint | Not Upheld | Miss Excel | Ireland | 05/05/2019 | ||
| 8 | 201/20 | 05/04/2020 | Littering | Unfounded | June Brown | Wales | 06/06/2020 | ||
| 9 | |||||||||
Data Table | |||||||||
