Problem Transposing between workbooks

[coreytroy]

Please Login or Register  to view this content.

I don't seem to be able to obtain the correct syntax to Transpose between workbooks.

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[coreytroy]

I'd have to put code in a sample book and upload 2 books.

[Norie]

If you could that would be fine, because the code you've posted doesn't look quite right.

[coreytroy]

Here is an example scenario of what i am trying to achieve on a larger scale.
See attached

[coreytroy]

Ok.
Ihave updated the attached workbooks as a sample.
I have the code working, but in a Copy Paste format.
As i have a fair bit of data to copy / paste, and knowing this style of code can be slow, is there a more efficient way to accomplish this?
So the attached works as required, but was after a non-copy / paste method to be more efficient.