Dear all,
I have this below data set:
Input data set:
I would like to use VBA to create another table as below in which it populate value of each position in accordance to the headcount column and when i change the headcount value, the table below will be auto updated. I am new to VBA and so this is too difficult for me. Hope that you can help me on this since i spent half of my day learning without any luck.
Desired output
I have this below data set:
Input data set:
Position | Headcount |
A | 2 |
B | 3 |
C | 2 |
D | 2 |
E | 4 |
I would like to use VBA to create another table as below in which it populate value of each position in accordance to the headcount column and when i change the headcount value, the table below will be auto updated. I am new to VBA and so this is too difficult for me. Hope that you can help me on this since i spent half of my day learning without any luck.
Desired output
Position |
A |
A |
B |
B |
B |
C |
C |
D |
D |
E |
E |
E |
E |