Morning folks,
Hands up, I'm abit of an excel amateur. Hoping for abit of guidance and assistance.
-I've got a drop down list with 20 options.
-Each time the list of dropped down and 1 of the 20 options are selected I want the cells below to paste a selected cells layout I have created on sheet 3.
Basically, 1) is this even possible 2) how to do it?
I have my list of options on sheet 1, and I have my cell layouts per option on sheet 3.
Example:
If I select "Increase/Decrease in pipe depth greater than 50%" from the list on sheet 1, the beige space below needs to populate the 3 boxes on sheet 3 that can be found under the same title "Increase/Decrease in pipe depth greater than 50%".
Any and all thoughts on the matter are welcome.
cheers.
Bookmarks