|I am preparing a data generator tool by using excel macro. I want to design a macro which wil ask user how many records you want to generate? after user gives input, macro should run and set of rows should be autogenerated. |
I have 26 columns, out of which only ID columns need to be auto increment.
This thind should happen in same excel and in a same sheet.
Also i want to provide first record so that my remining records will be generated same way only id columns are incremented automatically on a button click.
Please help me on this.