Results 1 to 2 of 2

Randomly sample 30 columns from worksheet input and print them in worksheet Output

Threaded View

  1. #1
    Registered User
    Join Date
    02-01-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    33

    Randomly sample 30 columns from worksheet input and print them in worksheet Output

    I am seeking a macro that samples 30 columns at random from the input worksheet and prints them in the output worksheet as shown, I dont want the macro to select the same column from the input worksheet and all 30 selected should be unique.

    I have attached a sample worksheet for reference

    I have a little experience modifying VBA code but am struggling with this and havn't found anything similar to compare code

    Thanks for any assistance you can provide
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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