Create a Macro to move cells.

[maparreira]

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.

 

[hiker95]

maparreira,

Welcome to the MrExcel forum.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

To start off, and, so that we can get it right on the first try:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, flat text) try one of the following:

MrExcel HTML Maker
If you do not know how to install and how to use HTML Mr.Excel Maker
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be

Excel Jeanie
Download

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here


Or, you can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.