Hi I am trying to copy selected data bits from one workbook to another while compiling the data in rows. My goal is to be able to copy over data quickly if I change some of the inputs.
here is my code so far
Sub findata()
'
' findata Macro
'
' Keyboard Shortcut: Ctrl+u
'
ActiveCell.Offset(-13, -9).Range("a1").Select
Windows("model.xlsm").Activate
Sheets("Financial Highlights").Select
ActiveWindow.SmallScroll Down:=9
ActiveCell.Offset(11, 0).Range("A1").Select
Selection.Copy
Windows("price analysis.xlsx").Activate
ActiveCell.Offset(0, 3).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("model.xlsm").Activate
ActiveCell.Offset(2, 0).Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
ActiveCell.Offset(2, -1).Range("A1:K5").Select
Windows("price analysis.xlsx").Activate
ActiveCell.Offset(0, -3).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("model.xlsm").Activate
ActiveCell.Offset(4, 1).Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
Windows("price analysis.xlsx").Activate
ActiveCell.Offset(0, 1).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("model.xlsm").Activate
ActiveCell.Offset(13, 0).Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
Windows("price analysis.xlsx").Activate
ActiveCell.Offset(0, 1).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(0, 2).Range("A1").Select
Windows("Model.xlsm").Activate
ActiveCell.Offset(4, -1).Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
Windows("price analysis.xlsx").Activate
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("A1").Select
Windows("Model.xlsm").Activate
ActiveCell.Offset(-1, 0).Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
Windows("price analysis.xlsx").Activate
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("A1").Select
Windows("Model.xlsm").Activate
Sheets("Cash Flow Statement").Select
ActiveCell.Offset(-18, -7).Range("A1:J1").Select
Application.CutCopyMode = False
Selection.Copy
Windows("price analysis.xlsx").Activate
ActiveCell.Range("A1:J1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(1, -6).Range("A1").Select
End Sub
Bookmarks