Dropdown - Table clear based on selected item

[MMarius]

Hi,

Dropdownmenu: car1, car2, car3, car4, car5 (selected now Car1).

A	B	C	D	E
Test	520000	20-02-2018	580000	60000 (formula): D1-B1
Test2
Test3	320000	25-02-2018	325000	5000 (formula) D3-B1
Test4
test4

<tbody>
</tbody>

What I want:

This values are for Car1 (Selected in dropwdown). When i choose car2 (from dropdown), I want the values from B, C, D, E to be cleared (but keep the formulas) and only A to show. This I want for every card and to be remembed. So when I choose car5 and complete and come back to car1, car1 to be completed as above.

 

[MMarius]

Up. Can it be done somehow? i could not find anything related. Or maybe VBA?

Select car from dropdown (data validation -> list) => Clear from table: KM, Year, Color when chose another car but also to remember it.

So when I fill data for car1 (km, year and color) and chose car2, to be blank and be able to complete again... but when I go again to car1, to be already what I've typed.

Thanks