+ Reply to Thread
Results 1 to 1 of 1

Choose random rows based on criterias and copy to next sheet

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    66

    Question Choose random rows based on criterias and copy to next sheet

    Hello All,

    I tried a lot to get this output using formula combinations of RAND() RANDBETWEEN() CHOOSE() ETC. ETC. but couldn't get the desired output hence looking to check if this can be achieved by VBA.

    I've attached a sample workbook. It contains 2 sheets. 1st sheet has raw data from columns A to F and the criterias are listed in columns J to M. The output i'm seeking is to extract samples based on the criteria listed in columns J to M and paste the extracted sample size in sheet 2 i.e. Audit Sample.

    I would really appreciate if someone can let me know if this can be achieved using VBA. Incase if there's any additional information required please feel free to ask.
    Attached Files Attached Files

+ 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. VBA/Macro Copy Random Rows to different sheet
    By NewToExcelVBA21 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2021, 11:37 AM
  2. [SOLVED] Choose random text value from list based on value in another cell on the same row VBA
    By magellanhcm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2021, 12:02 AM
  3. Copy data from different sheet based on 2 criterias
    By boom302 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-19-2020, 10:29 PM
  4. Copy rows from the second workbook into the first one based on criterias
    By std51 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2016, 03:26 PM
  5. [SOLVED] Delete rows based on multiple criterias, copy/paste data and formulas
    By BQuek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2013, 01:36 PM
  6. [SOLVED] Macro for copying data from one column in sheet 2 based on two criterias in sheet 1
    By baardings in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2012, 01:50 PM
  7. Choose Random Value Based On List
    By kblaine in forum Excel General
    Replies: 5
    Last Post: 04-20-2011, 02:41 PM

Tags for this Thread

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