Log in

View Full Version : [SOLVED:] Copy from Active workbook to opened Master Workbook



chlin
10-24-2013, 03:43 AM
Hi Everyone,

I have a active workbook that I want to copy some data from the activesheet. The macro will be run from the master workbook which is c:\excel\masterwb.xlsm. Both workbooks are already opened. How do I create a macro to copy eg. Cell G5 from the activesheet to sheet1 of the master workbook? Any Help is appreciated.

Aflatoon
10-24-2013, 05:37 AM
For example:
application.activesheet.range("G5").copy destination:=thisworkbook.sheets("Sheet1").range("G5")

chlin
10-25-2013, 12:28 AM
Thanks! It works.