Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jul 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort DATA into groups and Formated it in EXCEL (1)

    hi, i really need some helps in generating data in excel to be formatted in below format. It seems macro will be able to do this, but i really have some problem in knowing the logic of producing it. If anyone have some ideas pls do provide me consultation regards this...really appreiciate the help..thanks alot.

    HOPING TO GET RESULT LIKE:

    CLUB ID: A001
    REJECT CODE: B02
    REJECT REASON: not used
    CARD NO DESC
    -------- ------------
    123456 PAYMENT MADE
    236544 PAYMENT MADE

    CLUB ID: A001
    REJECT CODE: R01
    REJECT REASON: use
    CARD NO DESC
    ------- -----------
    222336 NO PAYMENT


    TABLE DATA:

    CLUB ID REJ CODE REASON CARD NO DESC
    ------- -------- -------- -------- -------------
    A001 B02 not used 123456
    PAYMENT MADE

    A001 B02 not used 236544 PAYMENT MADE

    A001 R01 use 222336
    NO PAYMENT

    <font color=red>text</font color=red>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort DATA into groups and Formated it in EXCEL (1)

    Sorry, it is not at all clear what you want. I think that part of the problem is that the forum software is reformatting your input so that it does not look like what you are entering. To prevent this, you need to put what are called [ pre] tags before and after the text that you don't want reformatted. To do that, put a [ pre] (without the space between the [ and the p which I had to put there to get it to show up in this message) on the line before the formatted text. Then type or paste the formatted text. On the line following the formatted text put [ /pre] (again without the space between the [ and the /).

    Next, could you give a little more description of what you are trying to do. What are you entering? What cells is it in? How many "PAYMENT MADE" rows can there be? What do you want generated automatically? In what cells? On what sheet? etc., etc...
    Legare Coleman

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort DATA into groups and Formated it in EXCEL (1)

    I tried to put in the "pre" tags for you following Legare's suggestion, but it still looks unclear:
    <pre> CLUB ID: A001
    REJECT CODE: B02
    REJECT REASON: not used
    CARD NO DESC
    -------- ------------
    123456 PAYMENT MADE
    236544 PAYMENT MADE

    CLUB ID: A001
    REJECT CODE: R01
    REJECT REASON: use
    CARD NO DESC
    ------- -----------
    222336 NO PAYMENT


    TABLE DATA:

    CLUB ID REJ CODE REASON CARD NO DESC
    ------- -------- -------- -------- -------
    A001 B02 not used 123456
    PAYMENT MADE

    A001 B02 not used 236544 PAYMENT MADE

    A001 R01 use 222336
    NO PAYMENT
    </pre>

    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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