I have two sheet 1 and 2. in sheet 1 I have a button that browse a file and paste it in into the second sheet so I need help to be able to browse for the second sheet and be able to paste it under the first one that is already exist in sheet 2. I would appreciate your help
Sub hh()
'
' hh Macro
'
'
Range("A1:A11").Select
Selection.Copy
Sheets("Sheet1").Select
Range("B19").Select
ActiveSheet.Paste
ActiveWindow.SmallScroll Down:=9
Sheets("Sheet2").Select
Range("A2:A5").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet1").Select
Range("B30").Select
ActiveSheet.Paste
End Sub
i recoded this code manually
See Question&Answers more detail:os