I am trying to make a calculator that determines total yearly emissions of a fleet of aircraft. Every aircraft has a specific set of operations it carries out each year, which all create a different amount of emissions. Each of these operations create different amounts of emissions.
As my project is right now, there are two drop down menus. The first selects an aircraft, and the second selects an operation. "Select Operation" drop-down is dependent upon the selection in the "Aircraft" drop-down. You can enter the number of that type of aircraft into cell B3, and the # of that particular operation per year in D3, and the following cells read the emission data for that operation. The program then adds those numbers to array D4:K4, displaying the total calculated emissions
Since adding the aircraft emissions together operation by operation is tedious, I want to make it so that rather than having a "Select Operation" drop-down, a table displaying each possible operation is displayed depending on the aircraft selection. The table should change size depending on selection as well, as some aircraft have different numbers of operations.
Thanks in advance, this is my first major project in Excel. I'm new to this forum so message me if you need a link to the spreadsheet.
Bookmarks