I just started trying to use VBA and have run into a problem that I haven't been able to work through.

Lets say in column A I have values 1-20 and in column B there are random numbers. In range E1:H8, the numbers from column A are located randomly. Would it be possible to replace the numbers in range E1:H8 with their corresponding numbers in column B?

<tbody>

</tbody>

Any help would be much appreciated!

Lets say in column A I have values 1-20 and in column B there are random numbers. In range E1:H8, the numbers from column A are located randomly. Would it be possible to replace the numbers in range E1:H8 with their corresponding numbers in column B?

A | B | C | D | E | F | G | H |

1 | 49 | 1 | 3 | 2 | 4 | ||

2 | 48 | 8 | 7 | 5 | 6 | ||

3 | 47 | 9 | 10 | 11 | 12 | ||

4 | 46 | 13 | 17 | 14 | |||

5 | 45 | 15 | 16 | ||||

6 | 44 | 18 | |||||

7 | 43 | 19 | |||||

8 | 42 | 20 | |||||

9 | 41 | ||||||

10 | 40 | ||||||

11 | 32 | ||||||

12 | 54 | ||||||

13 | 26 | ||||||

14 | 12 | ||||||

15 | 57 | ||||||

16 | 38 | ||||||

17 | 69 | ||||||

18 | 24 | ||||||

19 | 27 | ||||||

20 | 38 |

<tbody>

</tbody>

Any help would be much appreciated!

Last edited: