I am trying to perform the following task with excel...
I have created a dropdown menu... what i would like to do is make the data in a range of cells change depending upon what is selected in the dropdown menu... For example... i have 2 columns... one that says quantity, the other says price. In the dropdown menu there is 2 choices... concrete blocks and bricks. So when i select concrete blocks i would like the price and quantity to show the relevant figures which will be drawn from another spreadsheet. Is this possible??