Paste Column But Change Order

  • I have two worksheets... "TRANSACTIONS" and "MANUAL ADJUSTMENTS"
    The two sheets have similar types of data but the columns are in different orders.

    Here is what I've got so far:

    I am happy to search for solutions (I've learned tons :) just reading other posts) but I don't seem to know what to search for...

    any help is very much appreciated!

  • Re: Paste Column But Change Order

    Hello, charlesa920!

    If I understand correctly, the following will do it.

    Sub TransferData()
    Sheets("MANUAL ADJUSTMENTS").Range("A1:G" & Sheets("MANUAL ADJUSTMENTS").Range("G65536").End(xlUp).Row).Copy Sheets("TRANSACTIONS").Range("A1")
    Sheets("MANUAL ADJUSTMENTS").Range("J1:K" & Sheets("MANUAL ADJUSTMENTS").Range("K65536").End(xlUp).Row).Copy Sheets("TRANSACTIONS").Range("J1")
    End Sub


Participate now!

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