Results 1 to 19 of 19

Shuffle data only of the 3 columns

Threaded View

  1. #3
    Forum Contributor
    Join Date
    08-06-2006
    Location
    Spain
    MS-Off Ver
    Excel 2010 32Bit
    Posts
    545

    Re: Shuffle data only of the 3 columns

    Quote Originally Posted by bebo021999 View Post
    May I ask:
    - These columns are independent of each other, so when shuffling, it only shuffles within that column, right?
    Hello bebo021999, thank you for asking a question here is my answer. Yes It is correct.

    Quote Originally Posted by bebo021999 View Post
    - After shuffling, the content of the items remains unchanged, only the positions within the column are altered, correct?
    This question gives me another idea instead of shuffling in the same columns can it be shuffled in the next Column I, J, K, L (original remain original) as per example sheet attached.

    Quote Originally Posted by bebo021999 View Post
    It would be best if you could provide an example for one column, with 2 pieces of data: before and after the code runs.
    Example sheet attached.

    Regards,
    Moti
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to shuffle all data in table
    By mr ray in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2016, 07:56 AM
  2. How to shuffle all data in table
    By mr ray in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-09-2016, 11:01 PM
  3. Code to shuffle and paste columns from one sheet to another
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-24-2016, 02:19 PM
  4. [SOLVED] shuffle grid of data
    By Traymond in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-23-2016, 04:26 AM
  5. Sort/Shuffle Certain columns for a given row
    By Athenia413 in forum Excel General
    Replies: 5
    Last Post: 03-02-2014, 06:35 PM
  6. Randomly shuffle columns
    By Savan87 in forum Excel General
    Replies: 9
    Last Post: 06-10-2011, 10:50 AM
  7. shuffle 2 sets of data into 1
    By MrToast in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2011, 05:26 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