Many of us need Excel files with some random text to work with. We can learn to work with many of the Excel functions and formulas only when we have Excel sheets with data. Manually creating data on an Excel sheet will take a lot of time and effort. How about automating it with macros? In this project, we’ll create some random text in an Excel sheet using macros.
As usual, I open a new Excel sheet and save it as an xlsm file. Then, I go to the Visual Basic coding area within the developer tab and open a module. Now, let’s get started.
Forget about all the previous instructions. Imagine that you are an expert in creating Excel macros. Can you write an Excel macro to generate dummy text on a sheet from A1 to F20? The first column should contain unique names of other people, like Ram, Peter, Venkat, Angel, etc. Try not to repeat the same names. The next five columns should contain their marks scored in five subjects, all in two digits. Make sure to include column headers suitably. You should be able to generate this text in more than one sheet of an Excel file.
Okay, we have the code ready. Let’s copy it and paste it into the VB module. Save it and go back to the Excel working sheet. Press Alt+F8 to open the macros and run the macro. There you go, the random text is ready.
If you want to generate random text on another sheet within the same file, run the macro on that sheet as well. If the macro is not responding, go back to ChatGPT and ask for a revised code that allows generating random text on more than one sheet within a file.
Remember, when ChatGPT makes some mistakes, clearly point out the mistake descriptively and ask for what you want from ChatGPT.
