+ Reply to Thread
Results 1 to 3 of 3

Data (in columns) Manipulation/Re-arrangement using VBA

  1. #1
    Registered User
    Join Date
    05-28-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    19

    Question Data (in columns) Manipulation/Re-arrangement using VBA

    Hi,

    I am trying to re-arrange my data in specific algorithm. I think it is hard to explain so I will just show what I am trying to do.

    I have this data and a specific algorithm and i need to rearrange the data.
    Please Login or Register  to view this content.
    What I am trying to achieve
    Please Login or Register  to view this content.
    I am now trying FOR loops and I am stuck.. I am sure there is a simpler way!
    Last edited by excelnewbie80; 06-20-2012 at 11:59 PM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Data (in columns) Manipulation/Re-arrangement using VBA

    Hi

    This assumes that columns F:I are available as a temporary storage area
    Please Login or Register  to view this content.
    rylo

  3. #3
    Registered User
    Join Date
    05-28-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Data (in columns) Manipulation/Re-arrangement using VBA

    Wow it worked! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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