move several columns and sort according to the one particular column

  • Re: move several columns and sort according to the one particular column


    And if there is no match the row is moved to its own row on sheet 3? If no match of data on Sheet 1 then copy to left side of Sheet 3 and if no data match on Sheet 2 then move to Right side of Sheet3? Is that correct?

    Regards
    [SIZE=3]Anthony
    [/SIZE]&WCF_AMPERSAND[SIZE=3]
    [/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]




  • Re: move several columns and sort according to the one particular column


    Try - See attached workbook - if I understand your logic the following should do what you require

    Files

    Regards
    [SIZE=3]Anthony
    [/SIZE]&WCF_AMPERSAND[SIZE=3]
    [/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]




  • Re: move several columns and sort according to the one particular column


    Quote from smuzoen;699838

    And if there is no match the row is moved to its own row on sheet 3? If no match of data on Sheet 1 then copy to left side of Sheet 3 and if no data match on Sheet 2 then move to Right side of Sheet3? Is that correct?


    Yes it does..


    It really works awesome Thank you very much

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!