How to extract records randomly from Excel Sheet1 to Sheet2?

September 3, 2017 at 20:46:56
Specs: Windows 10
I have two excel worksheets and sheet1 contains 100 records in column A to column E. I want to extract 20 records randomly from sheet1 to sheet2. This will be happened when I click on a command button that to be placed on sheet1. Every time When I click on the command button, new set of records will be appeared in sheet2. How to do this?

See More: How to extract records randomly from Excel Sheet1 to Sheet2?

Reply ↓  Report •

#1
Reply ↓  Report •

#2
September 4, 2017 at 15:49:28
Thank you DerbyDad03

The code works perfectly. But I want to place a command button on the sheet 1. I am not sure how to write down those code under the command button. You can see my sample workbook in this like: https://drive.google.com/file/d/0B_... Would you please help me out? Thanks again.


Reply ↓  Report •
Related Solutions


Ask Question