- Jun 8, 2015
I need help in writing a macro to move cells. I'm a R/E agent and receive the data from MLS in a csv format. Row 1 are headings (in Column A through N) followed by 3 rows of data for each home sale. For example, A2 through F2, A3 through D3 and A4 through D4 is one transaction. I want to move the data from A3 through D3 to G2 through J2 and move A4 through D4 to K2 through N2. The next transaction is represented in Rows 5, 6 & 7 and so on throughout.