ExcelBanter

To: Mr. Peo:

Here is my original posting:
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

Was this post helpful to you?
Reply Top

R.VENKATARAMAN

12/28/2004 7:39 PM PST
Paste Special

In: microsoft.public.excel.misc

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

I HAVE NO IDEA HOW TO DO THIS AS I AM NOT FAMILIAR WITH VBA!!

Please advise.

"FLKULCHAR" wrote:

I received an answer to my yesterday query which included using a VBA
procedure.

I have NO idea what a VBA procedure is.

Please explain.

FL Kulchar