NileshAPatel
New Member
- Joined
- May 29, 2021
- Messages
- 26
- Office Version
- 365
- 2019
- Platform
- Windows
Hi everyone
I had prepared one macro which is working fine one source file is activated but it doesn't work when destination file is active not source. (Both files are open)
Is there any way that when Master file is active and data get copied from CustomerOrderReport file and paste in master file.
This macro is running fine when I select CustomerOrderReport file as active and showing on screen
but didn't work when Master file is active and showing on screen
Sub test()
'Copy paste only values
Workbooks("CustomerOrderReport.xls").ActiveSheet.Range(Range("A3").End(xlToRight), Range("A3").End(xlDown)).Copy
Workbooks("Master").Worksheets("Today").Range("D1").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub
Thanks in advance
I had prepared one macro which is working fine one source file is activated but it doesn't work when destination file is active not source. (Both files are open)
Is there any way that when Master file is active and data get copied from CustomerOrderReport file and paste in master file.
This macro is running fine when I select CustomerOrderReport file as active and showing on screen
but didn't work when Master file is active and showing on screen
Sub test()
'Copy paste only values
Workbooks("CustomerOrderReport.xls").ActiveSheet.Range(Range("A3").End(xlToRight), Range("A3").End(xlDown)).Copy
Workbooks("Master").Worksheets("Today").Range("D1").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub
Thanks in advance