Copy to Hidden Sheet

[sarails]

Hello Folks,

I have the following code which whilst it aint pretty, works great when the relevant sheets are visible.

I now need to adjust the code to as the only sheets visible are to be the Work Sheet and the Version History.
I'd appreciate some assistance on this as i've not been able to figure it out myself

Please Login or Register  to view this content.

I've tried doing it this way
Dim RngToCopy As Range

Please Login or Register  to view this content.

But it just copies in the literal sense and paste special just gives throws up errors on line entry

I have also added the file, all path names are updateable from the tab "Detail"
Thanks in advance

[pike]

Hi sarails

try adding the workbook names....

Please Login or Register  to view this content.

[sarails]

Hi sarails

try adding the workbook names....

Please Login or Register  to view this content.

Thanks Pike,
That works, but I need to the data to transpose from down to across.

[pike]

Hi sarails

what about this

Please Login or Register  to view this content.

[sarails]

Hi sarails

what about this

Please Login or Register  to view this content.

Thanks Pike
This works as needed

What's more I now understand why what you have coded works against what I have that didn't

Cheers
Iain