Posts by Anna Mary

    Hi


    Looking for a code to compare two workbooks and highlight the differences.

    I have 3 workbooks,

    Host.xlsm

    File1.xlsx( only sheet1 available)

    Flie2.xlsx( only sheet1 available)


    Below is the code but it doesn't work.


    Any help is appreciated. Thanks!


    Good Day,


    Please assist to trim the recorded macro.




    A table consist of same header, I'm replacing the header names with find and replace vba code.


    Ignoring the two matches and Replacing 3rd match, 4th match, 5th match as Apple,Mango and Orange respectively.


    Kindly refer to the attached file.


    -Anna

    royUK

    I receive 5-6 columns of data from a client.


    Scenario 1

    column_e, column_b, column_a, column_c,column_d


    <Reordering the columns and delivering the outputs>


    Reqd. Output

    column_a,column_b,column_c,column_d,column_e


    Scenario 2

    column_a, column_c, column_e, column_d,column_b


    Reqd. Output

    column_a,column_b,column_c,column_d,column_e


    Scenario 3

    column_a, column_c, column_e, column_d,column_b,column_f


    Reqd. Output

    column_a,column_b,column_c,column_d,column_e


    As you can see the reqd. output, column order is fixed (column_a,column_b,column_c,column_d,column_e),

    But I get inputs in different column order. I'm looking for a code which can work dynamically. Irrespective of the input, the columns should get rearranged to a,b,c,d,e..