How to use macro to copy data from workfile A to workfile B

MilliY Posts 1 Registration date Thursday August 13, 2015 Status Member Last seen October 4, 2015 - Oct 4, 2015 at 02:47 PM
 Sad - Oct 6, 2015 at 02:21 PM

COuld you please advise me how can I use macro coding to copy data from workfile A to workfile B? Example details :-

Source data copy from:-
'File name:WorkfileA
'Sheet name: InboundRecord
'Range:A2:Z2 to Selection.End(xlDown)).Select

Paste to :
'File name:WorkfileB
'Sheet name: Inventory
'Range:A:Z & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues

Hope to get your kind advise. :)

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 6, 2015 at 12:07 PM
Many ways
on ways would be to set the workbook to variables

and then u can use reference to those workbooks
Issue unsolved