In April 2012 I delivered a 1 hour webinar called “Excel Macro Magic” in which I demonstrated how the power of macros and VBA can be used to automate tasks and enable Excel to achieve the impossible.
The webinar was recorded and the short clip below was taken from the recording. In it I demonstrate an automated Action Tracker that I created.
Hi I would like to understand how the macro works,
thank you
Hi Omar. The macro looks at column G for the current row. If it contains the word “Completed”, it selects all the data on that row, copies it, moves to the “completed” tab, selects the next blank row and pastes the data
Mike,
Great job with “Action Tracker” spreadsheet. Do you share templates of your work? Thank you for you time and support.
Is there a possibility to know how did you create this button?