Currently, in Microsoft Excel, I have developed a workbook that contains many
of the petroleum derivatives that going into the various chemicals that we
purchase for our organization. The main focus of this workbook is the graphs
that I have developed which show the price trends of these given derivatives.
I would like to a master sheet in this workbook with a dropdown menu that
could reference all of the supporting worksheets in the work book to that my
director can simply open the workbook, go to the mastersheet with a drop down
menu, pick the chemical name he wants to see via that menu, and have the
graph and data appear on that sheet. Is this possible?