Hi I have below long code which are nearly working. Its just a recorded code.
It copy selected columns between workbooks. I need help to do following.

Make the code much shorter.
Correct the code so I don't get problem with shape and range, which I sometime does, and get and error.
Both workbooks will be open on but will be good to be able to name the sheets with a input box, if its possible.


Please have a look and see if you can make some good changes.
Thanks in advance
Sincerely Abjac


Sub Macro2()
'
' Macro2 Macro
' Macro recorded 17-09-2014 by y99dew
'

'
    Windows("CheckDDSetups .xls").Activate
    Range("A2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("A3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("B2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("B3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("C2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("C3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("E2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("D3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("F2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("E3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("G2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("F3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("H2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("G3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("I2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("H3").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    Range("H19").Select
    Windows("CheckDDSetups .xls").Activate
    Range("J2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("K3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("K2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("I3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("L2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("J3").Select
    ActiveSheet.Paste
    Range("H33:H44").Select
    Windows("CheckDDSetups .xls").Activate
    Range("P2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("O3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("Q2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("N3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("R2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("P3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Windows("robottool.xls").Activate
    Windows("CheckDDSetups .xls").Activate
    Range("S2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("Q3").Select
    ActiveSheet.Paste
    Windows("CheckDDSetups .xls").Activate
    Range("T2").Select
    Range(Selection, Selection.End(xlToRight)).Select
    Range("IU30").Select
    Range("T2").Select
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = ""
    Range("T2:AR2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Windows("robottool.xls").Activate
    Range("S3").Select
    ActiveSheet.Paste
    
   
    Range("O1").Select
End Sub