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.
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.