put cell values in other cells on same sheet in active range

  • Hi,


    What I am trying to do is this:


    I paste in a bunch of rows into a worksheet and they are in the wrong columns


    e.g:


    A1 = a
    B1 = b
    C1 = c
    D1 = d
    E1 = f


    Row 1= a,b,c,d,e,f


    what I need to happen is to have the values put into other columns in the same row for all rows that have data:


    result:


    cell A1 value is cut and pasted into cell D1
    cell B1 value is cut and pasted into cell A1
    cell C1 value is cut and pasted into cell B1
    cell D1 value is deleted
    cell E1 value is cut and pasted into cell C1


    Row 1 should have resulted in: d,a,b, ,c


    now if there is info in row 2, same thing needs to happen, and so on for all rows that are not blank


    any help would be appreciated!


    thanks.

Participate now!

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