Hi,
If I had a sheet that had components of a car with stock for example:
Tyres 500
Engine 300
Chassis 250
1 car equals 4 tyres, 1 engine, 1 chassis
Is there a way I can:
A) calculate how many cars I can make
B) take 1 car out of stock (and it automatically remove the components from a separate sheet)?
Apologies if this is tricky but im certain there must be a way.
Thanks in advance
Bookmarks