Hello,
I have table like the one below. I'd like a macro to select a range in that table which I specify.
For example:
<tbody>
</tbody>
I hope this makes sense. Any guidance appreciated
I have table like the one below. I'd like a macro to select a range in that table which I specify.
For example:
- if I type 'Budget' in cell B2 and 'Quarter 4' in cell B3, I'd like the macro to select range F11:F14; or
- if I type 'Actual' in B2 and 'Quarter 2' in B3, I'd like the macro to select range D6:D10
A | B | C | D | E | F | |
1 | ||||||
2 | Row input: | Budget | ||||
3 | Column input: | Quarter 4 | ||||
4 | ||||||
5 | Line | Type | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 |
6 | Revenue | Actual | ||||
7 | Personnel costs | Actual | ||||
8 | Admin costs | Actual | ||||
9 | R&D costs | Actual | ||||
10 | Profit | Actual | ||||
11 | Revenue | Budget | ||||
12 | Personnel costs | Budget | ||||
13 | Admin costs | Budget | ||||
14 | R&D costs | Budget |
<tbody>
</tbody>
I hope this makes sense. Any guidance appreciated