Re: Drop Down Menu with Two Possible Prefilled Scenarios
Disregard
Posts by actinogen
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
-
-
Hello there Excel masters and others on Ozgrid,
I have been tasked with making an excel sheet that has a drop down menu with two option (I figured out how to do this) and for those two options to do prefilled data of the number 1. Attached is the excel file. I am basically trying to tie the list worksheet with the indicated options in the drop down. The examples I have read online have the data right next to each other, but for these two options the number 1's jump from column to column. Seems simple enough right? Anyone have some tips?