Drop Down Menu with Two Possible Prefilled Scenarios

  • 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?

    Files

    • Document.xlsx

      (15.61 kB, downloaded 47 times, last: )