Hello,
Dropdown cars: car1, car2, car3, car4, car5.... (selected car1)
A.)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Car 1
[/TD]
[TD]Test2
[/TD]
[TD]4.000
[/TD]
[/TR]
[TR]
[TD]Car 1
[/TD]
[TD]Test3
[/TD]
[TD]8.000
[/TD]
[/TR]
[TR]
[TD]Car 2...
Car 3...
[/TD]
[TD]Etc
[/TD]
[TD]Etc
[/TD]
[/TR]
</tbody>[/TABLE]
B.)
[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]Test1
[/TD]
[TD]100.000
[/TD]
[TD]97000
[/TD]
[TD]167.000
[/TD]
[TD]Formula: B1+C1-D1 => 30.000
[/TD]
[/TR]
[TR]
[TD]Test2
[/TD]
[TD]200.000
[/TD]
[TD]99.000
[/TD]
[TD]295.000
[/TD]
[TD]Formula: b2+c2-d2 => 4.000
[/TD]
[/TR]
[TR]
[TD]Test3
[/TD]
[TD]200.000
[/TD]
[TD]90.000
[/TD]
[TD]282.000
[/TD]
[TD]Formula: b3+c3-d3 => 8.000
[/TD]
[/TR]
</tbody>[/TABLE]
What I want:
Table A.) to be populated automatically based on the values from table B (is in the same sheet).
So when from "E" (table B.) the result is below 10.000 to be populated automatically in table A.) with the following criteria:
- Car from dropdown
- "A"
- "E"
This has to be checked on every dropdown car and complete it automatically. After the number reaches above "10.000", from table A.) to be removed and only keep it in Table B.)
Dropdown cars: car1, car2, car3, car4, car5.... (selected car1)
A.)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Car 1
[/TD]
[TD]Test2
[/TD]
[TD]4.000
[/TD]
[/TR]
[TR]
[TD]Car 1
[/TD]
[TD]Test3
[/TD]
[TD]8.000
[/TD]
[/TR]
[TR]
[TD]Car 2...
Car 3...
[/TD]
[TD]Etc
[/TD]
[TD]Etc
[/TD]
[/TR]
</tbody>[/TABLE]
B.)
[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]Test1
[/TD]
[TD]100.000
[/TD]
[TD]97000
[/TD]
[TD]167.000
[/TD]
[TD]Formula: B1+C1-D1 => 30.000
[/TD]
[/TR]
[TR]
[TD]Test2
[/TD]
[TD]200.000
[/TD]
[TD]99.000
[/TD]
[TD]295.000
[/TD]
[TD]Formula: b2+c2-d2 => 4.000
[/TD]
[/TR]
[TR]
[TD]Test3
[/TD]
[TD]200.000
[/TD]
[TD]90.000
[/TD]
[TD]282.000
[/TD]
[TD]Formula: b3+c3-d3 => 8.000
[/TD]
[/TR]
</tbody>[/TABLE]
What I want:
Table A.) to be populated automatically based on the values from table B (is in the same sheet).
So when from "E" (table B.) the result is below 10.000 to be populated automatically in table A.) with the following criteria:
- Car from dropdown
- "A"
- "E"
This has to be checked on every dropdown car and complete it automatically. After the number reaches above "10.000", from table A.) to be removed and only keep it in Table B.)