Demosassiner
New Member
- Joined
- Aug 13, 2017
- Messages
- 7
To be honest, I don't even know how to explain this fully in words, hoping the table will illustrate the dilemma.
I have a data validation list in column F, with the appropriate selection made in cell E2 e.g. "white" in table 1.
Table 1
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
I need to populate column A with the appropriate selection from the data validation list, which is "white" as shown in table 2.
Table 2
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
I need to use a script to say that, if "both" is selected, populate "black" AND "white" in table A by copy-pasting the B and C selection downwards, and then proceeding to add the terms to the A column such as is shown below.
Table 3
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Hope this is somewhat clear.
I have a data validation list in column F, with the appropriate selection made in cell E2 e.g. "white" in table 1.
Table 1
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Micro | MICR | Data Validation List | |||
2 | Apple123 | AAPL | White | Black | ||
3 | Fbook1 | FBBC | White | |||
4 | Fbuckeyd | FACE | Both |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
I need to populate column A with the appropriate selection from the data validation list, which is "white" as shown in table 2.
Table 2
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
8 | White | Micro | MICR | White | Black | |
9 | White | Apple123 | AAPL | White | ||
10 | White | Fbook1 | FBBC | Both | ||
11 | White | Fbuckeyd | FACE |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
I need to use a script to say that, if "both" is selected, populate "black" AND "white" in table A by copy-pasting the B and C selection downwards, and then proceeding to add the terms to the A column such as is shown below.
Table 3
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
14 | Black | Micro | MICR | Both | Black | |
15 | Black | Apple123 | AAPL | White | ||
16 | Black | Fbook1 | FBBC | Both | ||
17 | Black | Fbuckeyd | FACE | |||
18 | White | Black | MICR | |||
19 | White | Apple123 | AAPL | |||
20 | White | Fbook1 | FBBC | |||
21 | White | Fbuckeyd | FACE |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Hope this is somewhat clear.