Excel VBA - Opening/Copying from another work sheet
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
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.
Copy "SheetA" from oldemployeefile.xls and copy it to sheet called "oldemployeefile" within my master.
Can someone please assist me in this?