I have been struggling with this for some time. There are two workbooks, one for entering all data (expenditures in the attachment), the other to show entries just for one category (vehicle1, vehicle2 in the attachment).
If an entry is made on 'expenditure' in columns E G L M N & S, with the entry in S being '2', then copy the entry to the next empty row in its own workbook 'vehicle2'
Kind of like 'IF S=1 copy to vehicle1, but IF S=2 copy to vehicle2 and so on.
Suggestions most appreciated.