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

[ashaanna88]

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

[mike7952]

Give this a try

Please Login or Register  to view this content.

[ashaanna88]

Thanks Mike for this help !!

This code is working fine when I create a New Macro project. But when i try to merge it with my project, its showing 'Run time error:1004' at Sheet2.Range("a1").Resize(n, 2) = arrResults

One more thing,
I needed random values for Account Number and Service numbers. It should not be a Constant value.
And I prefer Integer values to String for both Account Number and Service Number.

PFA the example i am Searching for.
Thanks a lot for providing this help !!

Regards,
Asha

[mike7952]

Change

Please Login or Register  to view this content.

to: Replace NameOfDestSheet to you sheet name

Please Login or Register  to view this content.