EXCEL/VBA copy multiple cell from other workbook into 1 workbook

[Closed]
Report
Posts
1
Registration date
Thursday July 23, 2015
Status
Member
Last seen
July 23, 2015
-
Hello,

I would like to copy couple of cell from multiple workbook into 1 workbook using Marco/VB.

Example:
Source
C:\temp\A.xls. Cell needed AB59
C:\temp\B.xls. Cell needed C36
C:\temp\C.xls. Cell needed A45

All to active workbook.
AB59 = A23
C36 = A25
A45 = A27

Please assist/help me. Thanks in advanced.


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!