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....................