Microsoft Excel Tips and Tricks
I demonstrate how to automatically transfer data from one worksheet to another using a VBA macro. In the example used in this video, a call centre operative records a call’s detail of a call on a form in one worksheet and then is able to click a button to transfer the details over to a call log on another worksheet.Credit Chester Tugwell