Results 1 to 9 of 9
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Order column based CTR (2000 sr 1)

    The shett cointain many value into column D E F (first block), G H I (second block)... ecc...

    All block are identified from SPORT, CTR and RAP.

    Is possible, with a mcro to:

    Into first 4 blocks insert the value identified from CTR 0000
    Into second 4 blocks insert the value identified from CTR 0011
    ....
    ecc...

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Order column based CTR (2000 sr 1)

    Could you elaborate? I don't understand what you want to do?

    Steve

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Order column based CTR (2000 sr 1)

    in effect move to the left all block... ordered wit CTR see the sheet FINAL
    Ordering from line and not from a column....

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Order column based CTR (2000 sr 1)

    Do you mean that you want the worksheet to be sorted left to right, then on to the next row, etc.?

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Order column based CTR (2000 sr 1)

    I still don't understand. What do you want it to look like at the end?

    The worksheet "final" is blank (except for headers). If you want it to look like that, clear the cell contents can do that easily... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Steve

  6. #6
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Order column based CTR (2000 sr 1)

    Music...
    "Only You..."
    Perfect...You have undrstand my problem fast.
    My vote for you on Eglish/Italian/Napolitan language is:
    10 and lode!

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Order column based CTR (2000 sr 1)

    See if the attached code does what you want. The macro named Transform is the one to run.

  8. #8
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Order column based CTR (2000 sr 1)

    Hans tks for fast reply, but the result of your macro not is the really wath i want...
    Explain:

    Note: one line for each User

    The column A contain index of user
    The column B contain the name of User
    The column C contain other code of User

    The columns D E F contain the number account (column A Agency, B Type of Account, C Number)
    G H I contain the information of other number account, if the user have other, J K L contain the indication of other number account, if the user have other... ecc....

    I wold want to order each line of user in this mode:

    I have insert into sheet FINAL the final result of ordering.

    The line 4 (user NAME002) have 3 Account number identified from CTR 0000 move the block 1 into D4 E4 F4, move the block 2 into G4 H4 I4, move the block 3 into J4 K4 L4, finsh ordreing for CTR 0000...

    The line 4 (user NAME002) have 2 Account number identified from CTR 0011 move the block 1 P4 R4 Q4, move the block 2 S4 T4 U4, finish the ordering for CTR 0011...

    I have ipotized that for each User have max 4 block of CTR...

    In effect make ordering in orizontal not in vertical shift to left the cells...

    I hope i am clear...

    Tks my good friend for patience.
    Sal-

    Attached new xls

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Order column based CTR (2000 sr 1)

    Sal,

    You're asking too much. As I have noted before, the purpose of the Lounge is to help its members to create applications, not to create the applications for them.

Posting Permissions

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