Posts by Anna Mary

    royUK Thanks for your reply. Because I require column order to be rearranged in specific order.


    Input reports are stored in different formats. Before fetching the output ( Default template) I require the data to get delimit and rearrange the column order and update the output.


    Attaching the test file shortly.

    Good Day,


    Require assistance in trimming the below code + borders to be included for the range that consist text.


    Please help to trim the code - Anna

    vcoolio this code works perfect.. Thanks a lot


    could you please explain the code how it works,


    Because the required output column order is this(1,2,3,4,5,6,7,8,9,10,11)


    In your code its specified as random order "Array(1, 2, 3, 10, 11, 12, 4, 5, 6, 7, 8)" and "column 9" header is missing (in the code).


    Additionally, is it possible to delimit and extract the data in output sheet?

    For eg..

    Input:-

    Column 10 has the below data

    1-2 Days Australia

    13-14 Days way Vietnam

    5-6


    Required Output:

    Col.8

    1-2

    13-14

    5-6


    Col.9

    Australia

    Vietnam

    <blank>


    alansidman


    Thanks for your reply..


    Is it possible to customize the order list? Because in the real data, Column headers will be in string..