Macro to copy paste columns to specific rows

**ohjeez** · 01-31-2011, 06:36 AM

Hi,

This is a bit of a strange one - but probably relatively simple, I'll be honest I'm an amateur when it comes to macros.

Basically what I would like to do is copy and paste 3 columns to specific rows. See attached for a sample of dummy data.

What I would like to do is copy and paste
C1 to A2, D2 to A3, E1 to A4
then
C5 to A6, D5 to A7, E5 to A8
then
C9 to A10, D9 to A11, E9 to A12
then
C13 to A14, D13 to A15, E13 to A16
etc
etc
etc
I have a full sheet of data like this, so would like a macro which would convert it all for me.

Thanks in advance.

**snb** · 01-31-2011, 06:52 AM

Please Login or Register  to view this content.

**ohjeez** · 01-31-2011, 07:46 AM

Thanks very much snb!
To complicate things what can I do if some of the columns don't have data in them. Say for example D1 was blank - I still want C1 to A2, D1 to A3, E1 to A4 - but A3 would be blank as it is copying a blank value form D1?
Thanks for your help so far!