Skillance10x Pvt Ltd.’s Post

Transcript

Let me show you a real world problem which comes in automation. How to compile data from multiple cell files in a selected seed without touching a single line of a code. I would say two is back. The work supposed to be done with VBN micros. There was a time when there was no ChatGPT used to learn programming then coded, then go back and forth and rectify all the errors then debug it. All these steps. Now you have a chat GVHD which can do all of these in less than 5. Let me show you how you can do exactly the same. But before guys, I have already made notes for it. So I'm going to simply search for notion in my browser. Now my browser is opened in the search bar I simply type the notion my notes have opened. I'm going to simply copy this from for the time saving purpose. Or you can manually write it out. Let me copy this form. I have copied the prompt let me switch back to ChatGPT. For this I'm again use the my Edge browser. The chat GPD has opened in the send a message box. Can you see that I'll simply paste the prompt that I copy from the notion for this I'm going to pass the control plus V in the key. Now let's understand the prompt. This prompt will tell the ChatGPT generate a VBA code that creating content of index that will copy the data from multiple excel file in a selected seat. When I add the enter. Now see magic is happening. I am going to simply copy this code. For the copy this code look at the copy button. Once you click add the copy button the code will copy it. Now let me switch back to excel. I am going to create a blank workbook. Click add the new, then click add blank workbook. Blank workbook is open. Let me put some text over here. In seat one I am going to put a capital A. In C2 I'm going to put a capital B. And in C3. I'm going to put a capital. See. Now now what I need to do. I'm going to simply developer tab then in the code section I have Visual basic. For this there's a shortcut based alt F11 or in some other laptop it will be Alt function key F 11. But remember press these keys. Once I click add the visual basic it will open a visual basic for application. On the left hand side we have a VBA project book one. Under this we have a multiple seat seat one seat two seat 3 under the. Under the seat three we have this workbook selected. Then double click on it. Now the Visual Basic for Application Code window will pop up. Simply go there and paste. The code that you copied from the chat support this. I'm going to paste control V in the keyboard. Now the code will copy it. At the very end you need to run this code this function F5 or you can. Or you can just click on the run button once you click add the run button. Now you can see the new seed which is index is created and at the left hand side we have a Ashar number. Then we have a workbook name then we have a worksheet name. At the very end we have a description. But notice one thing seed one, seed two, seed three. If you notice in a worksheet name have hyperlink it. Once you click the hyperlink it will directly take me to that seed. When I click add the seed two it will directly take me to the seed two. Now you can see I'm standing the seed two. So how the entire world. Has come when it comes to AI and chat GVT.