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. Details:
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.
re: i want to provide first record so that my remining records will be generated How will you "provide" the first record? Will it already be in a cell? If so, what cell?
What column should contain the auto-generated ID's?
We need more detail before we can offer a solution.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.