View Single Post
  #1 (permalink)  
Old April 21st, 2017, 03:06 PM
biggreenmelon biggreenmelon is offline
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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,
Reply With Quote