Copy and Paste based on Row.

Ok, so I know what I want excel to do but I do not know how to properly write it or where to start. I have 500 Rows with data. In Column A going down I have the numbers 1 - 500 as a reference point to each column. In Row 1, I have information that I need in Column C, E, G, H that I need to be copied and placed into a new worksheet.

However, I need a worksheet created for each 500 rows. So When Column 1 gets copied, it will copy C,E,G,H and then create a new sheet labeled 1, and paste them into the right spots. C will be pasted into D5. E into H7. G into I10. and finally H into B3. This would complete Row 1, I would then need to do the same thing for Row 2, all the way to row 5. Copying and creating a new sheet for each row. Would be the same Columns copied just appropiate to the row.


Could someone please help me with this or provide direction.

If I understand your wish right, try this on a copy of your original.

Please Login or Register  to view this content.