Random from random values ​​in Excel?

Question

Visual Basic

Hey! There is a sheet where literal values ​​are stored, which should be used in another sheet, but in a random order, that is, something like this.
The catch is that there are a lot of these values ​​​​and they are constantly being edited, and it takes a very long time to work with handles, if at all possible. With this data, I have to randomly fill in the entire table (cells (5, 128)). The difficulty for me is that all these values ​​are present, and not repeated in one line. Thanks in advance!

Answer 1

Random sort in Excel