The Iman Conover approach is a good method to generate correlated numbers.
The original paper by Iman and Conover you can find here.
Stephen J. Mildenhall published a very good paper on this approach here.
I created an Excel © file following the example given in Mildenhall’s paper:
The input matrix X: