Paste Special
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
|