vba code to copy number of rows in based on the input message

[prabhuduraraj09]

Hi all,

I have a autofiltered data, say which has 16 visible rows.

as per the input message, user inputs some number which will be less than 10.
say user inputs 6.

what i want is, i need a code to copy 6 rows of total visible 16 rows.
but it should pick random. not first 6 or last 6 rows.
it should pick random.....

i need that 6 rows to get copied to next sheet.

some body please respond..............the main part here is............
i need number of rows to be copied based on the input message, but Random. Any 6.

Please please some body help....................

[fredlo2010]

How many rows you would say your data has?

[prabhuduraraj09]

How many rows you would say your data has?

the number of rows, may vary.....based on the autofilter category.
it could be maximum of 30 rows. Definitely not more than that.......

so any time upon filtering the data, it will be less than 30 rows. And based on the input message number
say i give 12, then code should copy 12 random rows of total visible rows.

[fredlo2010]

Maybe something like this will help

Please Login or Register  to view this content.

Thanks