It can very well be that we in future decide to challenge ourselves, and start taking advanced classes, or that we try out many more different types of dance. 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 kommentar(er)
