I have a spreadsheet (attached) designed to calculate the savings a customer can make by using our energy saving lights compared to their existing lights. We have upgraded our range, and I would like to introduce some options which reflect this.
However, the drop down menus incorporating this information seem to be locked in some way, and I cannot access or modify the formulas or data that they refer to.
You will see that the first menu includes the kinds of lights that the customer already has, and the one below has details of our lights. The titles for the menus are located in cells X7 and onwards. But as I say, the formulas remain elusive. How can I reach them? Thank you for your time.
Bookmarks