Copy Cell From Workbook and Paste to Another Workbook's Cell

[nih]

Hello,

I need real help as some type of VBA code for this problem.

I need to create an automated process to copy data from book1 and book2 and paste it in another workbook called book3. I want vba code to do this task whenever I open my book3

Book1
Location: G:\FUTOMS-phases - eTD and TD\Reference Info\book1.xls
Data to be copied: Entire Rows 6 to 12
Paste: Book3> Sheet1

Book2
location: H:\Options\Info\book2.xls
Data to be copied:: Entire Rows 1 to 5 & rows 10 to 15
Paste: Book3>Sheet2

Is my explanation clear enough?
Please I really want to know the code for this problem.

Any help would be highly appreciated.

Thanks in advance!

[Salty Sea Dog]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[nih]

thx..I need to do both at the same time whenever I open my book 3 workbook.

[Salty Sea Dog]

Just write it as one Sub instead of two:

Please Login or Register  to view this content.