Advisory macro

[litrujilloh1]

Buen día. Agradezco consejos sobre lo siguiente:
Necesito un formulario de Excel que solicite un número del 1 al 100 y luego, en función de ese número, seleccione un rango asociado con ese número y péguelo en otro lugar. Ejemplo: Si el número seleccionado es 10, vaya a otra hoja y seleccione de A2 a D11, copie ese dato y péguelo en otra hoja. Gracias.

 

[sijpie]

That is not too difficult to achieve. But how does the macro decide which range to copy and where to copy it to?

• So if the user selects 1 which range is to be copied, and where does it need to be copied to?
• if the user selects 2 which range is to be copied, and where does it need to be copied to?

What is the logic for the selection of these ranges?

 

[litrujilloh1]

Thanks for write. Well, the idea is to make a macro that, according to what you type, copies the number of rows of a respective range in another sheet.

For example

message = "Enter the number of iterations"
title = "Financial Simulation"
a = InputBox(message, title)
b = Val(a)
Do While c < b

This capture if I type 2, go to a sheet, select 2 lines:
A1:D2 and paste it onto another sheet. But if I type 3 in the macro, it selects A1:D3 and pastes it on another sheet.

 

[sijpie]

Sorry that I did not reply to this yet. Do you still need help with it, oor has it been resolved?