mykal66
07-18-2019, 02:16 AM
Hi
I have a workbook with worksheets Data & Stats andtrying to copy the value of an active cell to a specific cell in anotherworkbook.
E.g. If the user clicks in any cell in the range A11-A20only (any other active cell does nothing) on the data sheet that value isautomatically copied over to Cell A2 on the Stats sheet
I have tried a few options from the net but can’t getanything to work, is anyone able to help please?
Thanks
Mykal
Active Cell,
I have a workbook with worksheets Data & Stats andtrying to copy the value of an active cell to a specific cell in anotherworkbook.
E.g. If the user clicks in any cell in the range A11-A20only (any other active cell does nothing) on the data sheet that value isautomatically copied over to Cell A2 on the Stats sheet
I have tried a few options from the net but can’t getanything to work, is anyone able to help please?
Thanks
Mykal
Active Cell,