Just in case I add more values, to the difficulty level, or when I decide to go wild and try out all kinds of dance classes. In column B and C, I left it ‘open-ended’. There are only 7 days in the week, so I don’t need the range in column A to ever take more than 7 values from a range. Of course, under List from a range, here you fill out Dropdowns C2:C.ĭid you notice that for column A, I wrote out two values referring to exact fields (A2:A8), but for column B and C I want the range to take anything it finds from B2 or C2, all the way down the sheet? This is on purpose. This means: go to Dropdowns tab, and copy all values you find in fields B2, all the way down to B (if there are any). In tab July, column B, I do the same thing, up to the range. This means: from Dropdowns tab, copy all values in fields A2 until A8. In tab July column A, I selected the entire column, right-click, choose ‘Data validation’, and enter ‘List from a range’. Then, fill out the name of the tab you want to pull from, an exclamation mark, and the range you need. You will be brought to this box! Choose ‘List from a range’. Once in tab July, select the full column, starting from B2: Right-click, then scroll down to Data Validation.
0 Comments
Leave a Reply. |