In this video, the speaker, Viorel, demonstrates how to use ChatGPT to create automation tools in Excel. He starts with an Excel file and wants to insert two rows after every other four rows using a VBA macro, but he doesn’t quite remember how to do it. To use ChatGPT, Viorel creates a free account and writes a question asking how to create a macro that inserts two rows every other four rows starting with the fifth row of the current worksheet. ChatGPT responds with instructions on how to open the Visual Basic window, write the code, and run the macro. The speaker then follows the instructions and successfully inserts two rows after every other four rows. However, ChatGPT initially calculated every six rows instead of four, so the speaker had to make adjustments to the code. The speaker concludes that ChatGPT is an amazing tool, even though it is in a test phase, and it is helpful for those who know the basics of programming language. He encourages viewers to like and subscribe for more content.
Leave A Comment