I am very rusty on VBA and need some help!
I need to delete rows within a range (rows 6 to 85) if the value in Column A does not equal B2.
I have pasted some example data below
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I need to delete rows within a range (rows 6 to 85) if the value in Column A does not equal B2.
I have pasted some example data below
A | B | C | |
1 | Currency | GBP | |
2 | Employee | Charlie | |
3 | |||
4 | Employee | Event name | Value |
5 | Abi | London | 2 |
6 | Becky | Singapore | 4 |
7 | Charlie | Paris | 3 |
8 | Dave | London | 4 |
9 | Ed | Singapore | 3 |
10 | Charlie | Paris | 6 |
11 | Dave | London | 3 |
12 | Ed | Singapore | 6 |
13 | Charlie | Paris | 4 |
14 | Abi | London | 3 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>