i went to contextures, found this sample sheet and have been using it
successfully

DV0003 - Order Form -- Select items from the dependent Data Validation
lists; a VLookup formula extracts the unit price. DataValOrder.zip 11 kb

does anybody know how i might split up these categories again with this or a
similar code ?
thanks