Paste Special

[Guest]

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

 

[R.VENKATARAMAN]

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
================

 

[Guest]

If you're not experienced with VBA, perhaps the simplest way is to use the
macro recorder to record the key strokes you use to copy data from one
spreadsheet to another. If you do so, make sure you hit the "Relative
Reference" button on the tool bar that pops up before entering your
keystrokes. Then, use keystrokes that seek the last row of the spreadsheet
where you want to append the data. Otherwise if you simply point to cell
"A6", for instance, then the macro will always try to write into cell A6
rather than at the bottom of your spreadsheet.