Create Automation / Macro in 2 Minutes

 

1. Download tool / template from link below

    Screen Shot 2017-09-07 at 9.24.50 PM

2. Put working files in the same folder as the template

   Screen Shot 2017-09-07 at 9.27.05 PM

3. Open the template

4. Click the refresh icon to refresh drop down list

Screen Shot 2017-09-07 at 9.28.15 PM

5. Select action, workbook, and sheet from drop-down list, then input range to create a task

6. Click Go to run task

Screen Shot 2017-09-07 at 9.29.53 PM

7. Create the next task

– Download Tool / Template –

MrCopyPaste.xlsb

 

– Intro: Excel Automation & Macro –