Updated: Jun 16, 2020
Yes this is possible! Its inbuilt in Excel itself.
All you have to do is do a couple of clicks and your macro is ready!
So, I had to create a very complex macro for a project and was going crazy. Me being super lazy thought that there has to be another way. Its MICROSOFT!
And...I was right. There is a brilliant way which can be used.
Ensure that you have your developer tab enabled and don't forget to save your file in Macro Enabled format. Create macro as shown in the video in our videos section, assign it to a button and its DONE!
Its all just CLICK CLICK CLICK and you are good to go! :)
Let me know if this has helped you by leaving a comment in the video.