Hi can anyone help with a macro that I could use with a drop down list that will find and select rows based on Name from column A and the Ref from column C (Sheet7)
IE if I wanted to find 1 as the name from column A and 10 as the Ref in column C in this example A14:J16 would be selected or if I wanted to find 0 as the Name and 15 as the Ref A8:J10 would be selected and so on... and then copy the selected range to Sheet3 A3:J
<tbody>
</tbody>
Any help would be appreciated
Regards
pwill
IE if I wanted to find 1 as the name from column A and 10 as the Ref in column C in this example A14:J16 would be selected or if I wanted to find 0 as the Name and 15 as the Ref A8:J10 would be selected and so on... and then copy the selected range to Sheet3 A3:J
A | B | C | D | E | F | G | H | I | J | K | L | M | |
1 | Name | Range | Ref | A | B | C | D | E | F | G | |||
2 | 0 | 1 - 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
3 | 0 | 6 - 10 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
4 | 0 | 11 - 15 | 5 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |||
5 | 0 | 1 - 10 | 10 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
6 | 0 | 11 - 20 | 10 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||
7 | 0 | 21 - 30 | 10 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |||
8 | 0 | 1 - 15 | 15 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |||
9 | 0 | 16 - 30 | 15 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |||
10 | 0 | 31 - 45 | 15 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |||
11 | 1 | 1 - 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
12 | 1 | 6 - 10 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
13 | 1 | 11 - 15 | 5 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |||
14 | 1 | 1 - 10 | 10 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
15 | 1 | 11 - 20 | 10 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||
16 | 1 | 21 - 30 | 10 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |||
17 | 1 | 1 - 15 | 15 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |||
18 | 1 | 16 - 30 | 15 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |||
19 | 1 | 31 - 45 | 15 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |||
20 | |||||||||||||
21 |
<tbody>
</tbody>
Any help would be appreciated
Regards
pwill
Last edited: