Excel VBA - Opening/Copying from another work sheet
Hello,
I am new to VBA and need a bit of help.
I am looking to create code that does the following:
I have three excel workbooks I am working with
my master: Master.Xlsm
NewEmployeeFile.xls
OldEmployeefile.xls
What I want to do is within my master. I want it to copy "SheetA" from Newemployeefile.xls and copy it to sheet called "NewEmployeefile" within my master.
And
Copy "SheetA" from oldemployeefile.xls and copy it to sheet called "oldemployeefile" within my master.
Can someone please assist me in this?
Thank you,
|