+ Reply to Thread
Results 1 to 2 of 2

VBA to select either number or % of random rows

  1. #1
    Registered User
    Join Date
    01-19-2021
    Location
    Boston
    MS-Off Ver
    365
    Posts
    1

    VBA to select either number or % of random rows

    Hello. I have a data set with 12 columns A --> L . There are 1000s of rows. My data set has a header. I'm looking for 2 macros - all related.
    First - Does anybody have the code to select either a specific # or a specific % of random rows from a range. And copy these results to another page.
    Second - I would then like to also get the same as above, but add in the condition: for each unique value in column A.
    For example, column A contains only numbers 4,9,8,97,98 - I would like to be able to get certain # or % for each of these numbers.
    Much appreciated. Have already spent an hour looking for this on-line with no luck.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: VBA to select either number or % of random rows

    Welcome to the forum. It would help us to help you if you could provide a sample file with the results you are expecting, as per the yellow banner above. How many random rows do you want copied over?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 11-04-2020, 03:41 AM
  2. Replies: 11
    Last Post: 11-19-2019, 11:36 PM
  3. [SOLVED] how to select lowest random number within each category
    By anita2017 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-11-2017, 11:39 AM
  4. Select Random Rows of Data
    By ThxInAdvance in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-10-2014, 04:22 PM
  5. Select Random Rows and Display on new sheet
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 02-27-2013, 06:54 AM
  6. Select Random Number from List
    By dreicer_Jarr in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-23-2009, 04:01 PM
  7. Select & Delete Random Consecutive Rows
    By carbonboywonder in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2009, 05:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1