Need macro code for filling values in Sheet 2 by taking input parameters from Sheet1

Hi All,

I am new to macro.

I need a help for the below scenario.
When we enter the value for the Account number and Service number in Sheet 1, a random number should be generated in Sheet 2 correspondingly.

PFA the excel showing an example.

The values in the first row for both Account number and Service number can be random values(can be Integer or String) and the rows below can be incremented.

Please help me in this regards and let me know if any more input from my side is required.

TIA.

Regards,
Asha