Need an Excel Macro to autogenerate records.

November 21, 2013 at 21:17:23
Specs: Windows 7
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.


See More: Need an Excel Macro to autogenerate records.

Report •


#1
November 22, 2013 at 05:02:12
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.


Report •
Related Solutions


Ask Question