Results 1 to 5 of 5

randomly select 30 products and copy the result

Threaded View

WasWodge randomly select 30 products... 01-30-2011, 03:13 PM
MarvinP Re: randomly select 30... 01-30-2011, 03:40 PM
WasWodge Re: randomly select 30... 01-30-2011, 03:57 PM
MarvinP Re: randomly select 30... 01-30-2011, 04:11 PM
WasWodge Re: randomly select 30... 01-30-2011, 04:35 PM
  1. #1
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    randomly select 30 products and copy the result

    Back again to ask what I hope will be a simple question to someone (Thanks again to Marcol for showing me earlier an easy way to remove an annoyance from the original file).

    In the attached sample workheet i want to randomly select 30 products and copy the result to a separate worksheet. So basically I need a macro (or something I can record to a macro) to randomly select 30 codes from column C and then copy the entire rows to a separate spreadsheet.
    As usual I will be most thankful for any guidance
    Attached Files Attached Files
    Last edited by WasWodge; 01-30-2011 at 04:36 PM.

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