+ Reply to Thread
Results 1 to 6 of 6

Arranging Data Justified way in equal rows

  1. 12-20-2008, 12:15 PM #1
    Flower R
    Flower R is offline
    Forum Contributor
    Join Date
    10-10-2008
    Location
    western hemisphere
    Posts
    128

    Arranging Data Justified way in equal rows

    Hello,

    I get text type data from a different sheet in the following way. The data is dispersed in different rows and entries range vary from row to row:

    1111 2222 3333
    4545 5454 6456 xwty mnb ypdxy zxty
    7678 9809 1234 4zpx howe ever

    I would like that it may be arranged like this in other rows so that the above original data may remain in its original form.

    1111 2222 3333 4545 5454 6456
    xwty mnby pdxy zxty 7678 9809
    1234 4zpx howe ever

    A VB Code help will be appreciated. Thanks.

    Flower R
    Last edited by Flower R; 12-20-2008 at 02:21 PM.
    Reply With QuoteRegister To Reply
  2. 12-20-2008, 01:08 PM #2
    Flower R
    Flower R is offline
    Forum Contributor
    Join Date
    10-10-2008
    Location
    western hemisphere
    Posts
    128
    Here is sample book.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 12-20-2008, 01:14 PM #3
    Raiby
    Raiby is offline
    Forum Contributor
    Join Date
    08-19-2006
    Posts
    116
    Hi

    Do you want to reorganize your data in the following way:6 cells on each row?
    I have just seen your file.I'm going to see it.
    Last edited by shg; 12-20-2008 at 01:23 PM. Reason: deleted spurious quote
    Reply With QuoteRegister To Reply
  4. 12-20-2008, 01:21 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Please Login or Register  to view this content.
    (Rearranges in place.)
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  5. 12-20-2008, 01:38 PM #5
    StephenR
    StephenR is offline
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606
    Very neatly done shg, I was just scratching my head over that one.
    Reply With QuoteRegister To Reply
  6. 12-20-2008, 02:20 PM #6
    Flower R
    Flower R is offline
    Forum Contributor
    Join Date
    10-10-2008
    Location
    western hemisphere
    Posts
    128
    Quote Originally Posted by shg View Post 
    Please Login or Register  to view this content.

    (Rearranges in place.)
    Perfect and a beauty.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1