p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2 (http://p2p.wrox.com/book-excel-2007-vba-programmers-reference-isbn-978-0-470-04643-2-316/)
-   -   Excel VBA - Opening/Copying from another work sheet (http://p2p.wrox.com/book-excel-2007-vba-programmers-reference-isbn-978-0-470-04643-2/99478-excel-vba-opening-copying-another-work-sheet.html)

biggreenmelon April 21st, 2017 02:06 PM

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,


All times are GMT -4. The time now is 09:18 PM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.