VBA Code

Closed
CADU1947 Posts 3 Registration date Friday December 4, 2015 Status Member Last seen December 4, 2015 - Dec 4, 2015 at 09:45 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 4, 2015 at 10:05 AM
I dont know how but I managed to put together a macro that copies transposed info entered in a column of one sheet to a row in another sheet. The problem is that the copy is made in the first upper row, offseting all rows down,cand I need to have it copy in the last available free row below. Don't know how to solve it, follows copt of the macro.
Sub Traspaso_Info()
'
' Traspaso_Info Macro
' Traspaso info traspuesta de una hoja a otra
'
' Keyboard Shortcut: Ctrl+a
Sheets("INFODE").Select
Range("B1:B14").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("INFOA").Select
Range("A2").Select
Selection.PasteSpecial , Transpose:=True
Selection.Insert Shift:=xlDown
End Sub
Thanks!!
Carlos

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 4, 2015 at 10:05 AM
1