Creating controlled random numbers across multiple columns

Hi All,

I am working on a data sheet (Sheet1) with one column (ColA) which has data groups/blocks that are separated with one empty row, as per attached example: random_numbers_example.xlsx

Data blocks are sequenced numbers that always start with number 1 and vary in size: one block could be 300 rows, another could only be 6 rows.

What I am after is to create extra five columns (B, C, D, E, F) with random numbers for each data block (as per Sheet2). The seeding number for creating random numbers is the same number that exists in ColA for each block.

The result is six columns (A:F) of data for each block with NO REPEATED NUMBERS across each row of data block.

Can I be helped with this problem, please?

Many thanks in advance.

T.

Thank you very much JBeaucaire for such masterpiece. It ran like magic, smoothly with no problem at all. Your code did resolve my problem, for which I do gratefully thank you. You do have a great input to this world.
All the best.
T.