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