+ Reply to Thread
Results 1 to 4 of 4

How to randomly delete X amount of rows from a sheet in a single command?

  1. #1
    Registered User
    Join Date
    09-11-2016
    Location
    Israel
    MS-Off Ver
    Home 2016
    Posts
    22

    How to randomly delete X amount of rows from a sheet in a single command?

    Hello

    I have a sheet with hundreds of rows with 3 columns with info (Cells A, B & C)

    I'd like to be able to add a line of code of some sort, that would randomly pick X amount , preferably in percentage parameter, meaning e.g. delete randomly 30% of the rows that contains info in cells.

    Please help

    Thanks

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: How to randomly delete X amount of rows from a sheet in a single command?

    This is not a one liner, but it is fairly short.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-11-2016
    Location
    Israel
    MS-Off Ver
    Home 2016
    Posts
    22

    Re: How to randomly delete X amount of rows from a sheet in a single command?

    Quote Originally Posted by JLGWhiz View Post
    This is not a one liner, but it is fairly short.
    Please Login or Register  to view this content.
    Hello

    Thanks for helping out

    Could you please help with how to perform this? I have only limited excel skills

  4. #4
    Registered User
    Join Date
    09-11-2016
    Location
    Israel
    MS-Off Ver
    Home 2016
    Posts
    22

    Re: How to randomly delete X amount of rows from a sheet in a single command?

    Quote Originally Posted by JLGWhiz View Post
    This is not a one liner, but it is fairly short.
    Please Login or Register  to view this content.
    could you please help me with execution?

+ 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. [SOLVED] Help on VBA code to delete a row in more than one table from a single command button
    By grahamlees in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2017, 05:46 AM
  2. [SOLVED] Delete Entire Row based on single cell value using VBA command Button
    By rain4uu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2014, 12:53 PM
  3. Merge Duplicate Rows unique values into single rows for an infinite amount of columns/rows
    By aimeecrystalaid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2013, 08:43 PM
  4. [SOLVED] VBA Randomly Select m amount from n amount of data, where m<n
    By doglover in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-23-2013, 03:44 AM
  5. How to delete rows that has X amount of words in them?
    By sami770 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2012, 09:48 AM
  6. Delete rows which contain x and -x in amount column
    By jcoffelt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2007, 12:58 PM
  7. [SOLVED] Delete Non-Randomly Chosen Rows
    By John in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2005, 10:20 PM

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