Hi There
I have a problem where I need rows to a new sheet based on multiple cell values in the row. I have 5 dropdown list box where the user selects values (with the possibility that the user can select multiple values in the dropdown list box) these values are picked up by the VBA to determine which row in the data sheet to copy. The bit that is perplexing me is that in the audience dropdown list the user can select yes, which means that any row, which has a yes in the sub audience needs to be copied.
Can anybody give me a head start with the code or suggest a better solution.
Dropdown list box examples
Excel 2010
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Data
Excel 2010t<d style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Yes</d>t<d style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">No</d>t<d style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">No</d>
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
I have a problem where I need rows to a new sheet based on multiple cell values in the row. I have 5 dropdown list box where the user selects values (with the possibility that the user can select multiple values in the dropdown list box) these values are picked up by the VBA to determine which row in the data sheet to copy. The bit that is perplexing me is that in the audience dropdown list the user can select yes, which means that any row, which has a yes in the sub audience needs to be copied.
Can anybody give me a head start with the code or suggest a better solution.
Dropdown list box examples
Excel 2010
A | B | |
---|---|---|
1 | Format | |
2 | ||
3 | ||
4 | ||
5 | ||
6 | Client (Max of 5) | |
7 | ||
8 | ||
9 | ||
10 | Brand (Max 5) | |
11 | ||
12 | ||
13 | ||
14 | Published | |
15 | ||
16 | ||
17 | ||
18 | Audience | |
19 | ||
20 | ||
21 | ||
22 |
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
V1
Data
Excel 2010t<d style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Yes</d>t<d style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">No</d>t<d style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">No</d>
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Audience | < style="font-weight: bold;text-align: center;border-bottom: 1px solid black;background-color: #FFFF00;;"> | ||||||||||||||||
2 | Format | Client | Brand | Published | Youth | Mum's on the Run | Tradesman | Female Commuter | Male Commuter | SME's | ABC1 | C2DE | Houswives with Kids | Men | Women | 15-24 | 35-64 | 65+ |
3 | Case Study | Master Foods | Mars | 2009 | No | No | No | No | No | No | No | No | No | No | No | |||
4 | Face to Face Research | Diageo | Guiness | 2008 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||
5 | Category Insight | 2007 | No | No | No | No | No | No | No | No | No | No | ||||||
6 | EPOS Data | 2010 | No | No | No | No | No | No | No | No | No | No | ||||||
7 | Pitch | |||||||||||||||||
8 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet3