create a vba procedure like this

Public Sub test()
Range("d5:d10").Copy
Workbooks("book2").Worksheets("sheet1").Range("B4" ). _
PasteSpecial xlPasteValues, Transpose:=True
End Sub

this sub is placed on the vbeditor of book1 where the column data is located
customise the sub to suit your needs.
your original data is in sheet1 and range d5 to d10
the data to be copied to book2, sheet1 and from B4
================
FLKULCHAR wrote in message
...
Every evening, I copy and paste a column of numbers into a row of
numbers...from one workbook to another, using the PASTE SPECIAL, TRANSPOSE
capabilities of EXCEL.

Since I do this EVERY DAY, is there a way I can bypass the PASTE SPECIAL
command via some instruction.thus telling the command to copy into a row
instead of a column?

In other words, I would like to speed up the process, click on the leading
cell, and then copy (what was once a column in another worksheet into a
row
on my new workbook).

Thanks,

Any pointers??

FL Kulchar