Automated Copy and Paste Using VBA

Hi All,

ScreenCap.JPG

I have a spread sheet (see attached image above) and would like to automate a process where by you can copy all the X data from the I, K, M and O columns in to the Q column. And copy all the Y data from the J, L, N and P columns. I have done the first 3 rows of data by copying each row and transposing it so it displays vertically. I also recored a macro to see what the code looks like when you do this by hand.

For the X data:

Please Login or Register  to view this content.

For the Y data:

Please Login or Register  to view this content.

I would like to make this process automatic. That is, have some sort of loop around the above code so that it runs through all the data and copies everything.

Hope that all makes sense.

Best Regards,

Aaron

Thanks for your offer. Much appreciated. However, I tinkered with it for a few hours and got it working. I hope you didn't spend any time on it.

Thanks again,

Aaron