Good morning,
I am looking for help with achieving the following using VBA:
cell DM20 - hyperlink to take user to 'Sheet2'!
cell B3 - value to copy
What i want to happen is when a user clicks on text in DM20, it takes them to 'Sheet2'! and pastes the value from 'Sheet1'!B3 into 'Sheet2'!B10...