Results 1 to 2 of 2

Cell's shuffling

Threaded View

  1. #1
    Registered User
    Join Date
    06-14-2015
    Location
    Moscow
    MS-Off Ver
    2013
    Posts
    1

    Talking Cell's shuffling

    Hello,
    I have a file with near 1000 lines.
    I need to shuffle cells.
    But there is dependence.

    Every two lines should be mixed in the same order.

    For example I have a table:
    1-2-3-4-5-6-7-8
    1-2-3-4-5-6-7-8
    1-2-3-4-5-6-7-8
    1-2-3-4-5-6-7-8
    1-2-3-4-5-6-7-8
    1-2-3-4-5-6-7-8

    And on exit I need

    2-5-7-4-6-8-1-3
    2-5-7-4-6-8-1-3
    5-6-3-1-2-7-8-4
    5-6-3-1-2-7-8-4
    3-8-1-2-7-6-4-5
    3-8-1-2-7-6-4-5

    I know how to mix cells randomly,
    Sub test()
    
    Rows(1).Insert
    Range("A1").Resize(1, Cells(2, Columns.Count).End(xlToLeft).Column).Formula = "=RAND()"
    Range("A1").CurrentRegion.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlNo, _
            OrderCustom:=1, Orientation:=xlLeftToRight
    Rows(1).Delete
    
    End Sub
    But how to do it in that case I don't know.

    I will be very glad if someone help me.

    Thank you for your answers.
    Last edited by AlienFromSpace; 06-14-2015 at 03:39 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Shuffling cells
    By MrBurns in forum Excel General
    Replies: 9
    Last Post: 08-21-2012, 12:32 AM
  2. Shuffling
    By Hell bent in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2012, 08:36 AM
  3. Data shuffling challenge
    By vnascimento in forum Excel General
    Replies: 4
    Last Post: 05-14-2012, 04:50 PM
  4. Shuffling data
    By CellGL5371 in forum Excel General
    Replies: 1
    Last Post: 03-04-2007, 04:10 PM
  5. Shuffling a List of Values
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-28-2005, 11:27 AM

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