Hi. I have an excel sheet with about 4,500 rows of data. For some reason the paste I received from the web splits each row on the web into 2 rows in excel. I am trying to take the data in row 3 (Cells A3 through E3) and move into row 2 (Cells G2 through K2). Then I would like the macro to either delete row 3 or go to row 5 and do the same cut and past of that data into the row above. Basically I would like themacro to do this for every odd row through row 4,500. Is this possible. Thank you.