ayman helmy
New Member
- Joined
- Mar 17, 2021
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
I Use the code below to copy S2 from Sheet2 to paste in k15 in sheet1
Then I run another macro as shown in the code I need to edit this code to do the same for all data in column S
Sub Copy()
'
' Copy Macro
'
'
Range("S2").Select
Selection.Copy
Sheets("Sheet1").Select
Range("K15").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Application.Run "Advance.xlsm!svpdf"
Sheets("Sheet2").Select
Then I run another macro as shown in the code I need to edit this code to do the same for all data in column S
Sub Copy()
'
' Copy Macro
'
'
Range("S2").Select
Selection.Copy
Sheets("Sheet1").Select
Range("K15").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Application.Run "Advance.xlsm!svpdf"
Sheets("Sheet2").Select