Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jan 2004
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Sorting Problem (Excel 2000)

    Hallo again

    I have one problem for which I need some guidance as how to solve it.

    I attach a workbook with 2 sheets. The one sheet contain the original data and the other the data in the format that it needs to be.

    On the original data sheet you will notice that there are MTN numbers with more than one entry against it (in the blue section)

    Each MTN needs to copy to the processed data, one line for each case where there are information written against it.
    Then the price in the top row has to copy against each item as shown in the processed data sheet.

    This is just a very small extract from the data I have to convert into this format. There are hundreds of rows and about 50 columns, I just reprodused a small section to explain the problem.

    Are there code available top do this or can anybody point me in the right direction.

    Thank you very much
    Regards
    Kobus

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Data Sorting Problem (Excel 2000)

    Hi,
    Is there a set number of columns or does it vary each time you have to do this (I'm assuming this is not a one time job)?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Jan 2004
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Sorting Problem (Excel 2000)

    At this moment there are 32, but it is not always the same. 50 should be the maximum.

    You are correct, it will be done at least once a month with a maximum of about 3 times per month.
    Thank you
    Regards
    Kobus

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Data Sorting Problem (Excel 2000)

    Try the attached version - it contains a subroutine called ProcessData that will ouput to a sheet called ProcData. I have not done any formatting, just the basic data rearrangement, but that can be added if necessary.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Data Sorting Problem (Excel 2000)

    Damn - Rory beat me to it....

    Output is to "FlatData," and routine must be run from initial data sheet. Now to compare to Rory's <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

  6. #6
    Star Lounger
    Join Date
    Jan 2004
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Sorting Problem (Excel 2000)

    Rory & Dean

    Thank you for your great work, this will save me hours and hours if not days of work per month. I do not know how I will solve all the problems without this Forum's help.

    I realy appreciate it.

    Thank you again
    Regards
    Kobus

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •