Alessio9899
New Member
- Joined
- May 10, 2019
- Messages
- 4
hello everyone,
I have little knowledge of the VBA language despite my efforts to learn more and more, but in this specific case I have no idea where to start and I hope you can help me.
Suppose you have a normal sheet that contains some data:
my goal would be to select a variable number of rows (the number of these rows depends on a specific value that I find in a cell in another sheet, for example if this value is 10 the macro should select 10 random rows from the data set shown above) and copy the result in a new sheet (header included):
i will put the code into a button to trigger everything (i already know how to do it) can you give me some ideas? Thanks
I have little knowledge of the VBA language despite my efforts to learn more and more, but in this specific case I have no idea where to start and I hope you can help me.
Suppose you have a normal sheet that contains some data:
my goal would be to select a variable number of rows (the number of these rows depends on a specific value that I find in a cell in another sheet, for example if this value is 10 the macro should select 10 random rows from the data set shown above) and copy the result in a new sheet (header included):
i will put the code into a button to trigger everything (i already know how to do it) can you give me some ideas? Thanks
