Copying numbers from 1 Spreadsheet to another

[gary66]

Hey All,
I'm having problems coping numbers from one spreadsheet to another.
The numbers I'm copying across go across the page. ie row
And the numbers from that row I want copy into another spreadsheet, but going down the column.
But when I paste the numbers from the row, it's pastes them in the row format, even when I have selected the column.
I hope I'm making sense here and I also hope someone has a solution to this....

[mudraker]

Gary

You need to use the PasteSpecial function, Ticking the Transpose box

[gary66]

Cheers Mudraker!!!!
U da man!!!