Dropdown - Table clear based on selected item

[MMarius]

Hi,

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]Test
[/TD]
[TD]520000
[/TD]
[TD]20-02-2018
[/TD]
[TD]580000
[/TD]
[TD]60000 (formula): D1-B1
[/TD]
[/TR]
[TR]
[TD]Test2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test3
[/TD]
[TD]320000
[/TD]
[TD]25-02-2018
[/TD]
[TD]325000
[/TD]
[TD]5000 (formula) D3-B1
[/TD]
[/TR]
[TR]
[TD]Test4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]test4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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