I need some custom work done to an MS Excel worksheet.
It will need:
- drop down lists embedded into a field
- choices in the drop down will affect another column
- some formulas
- it will function as a calculator
- it will need some formatting for appearance
I have attached a sheet I put together.
I need to add a drop down menu that will allow me specify other cities.
When the person selects a different city a new data column would be added into column "C" hours of operation which would change the other columns numbers. (I have all the data sorted that would be changed in hours of operation)
I would also like a drop down that would allow for column "D" to be changed. Column D is based on a number of BTUs for the size of the building. In the attached example I use 60,000 and divided it by the number of rows in column "C" which gives me the btus required to heat the building at different temperatures.
Once these details are worked out, I would like to make the calculator have an attractive look with hidden columns, colored cells, etc.