Need an Excel Macro to autogenerate records.

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.

• › An Excel Macro to find only the exact wordn & copy rows base
• › [Solved] EXCEL macro to copy paste row below when value changes?
• › [Solved] need a simple excel macro to create 31 sheets and name them
• › An Excel Macro to find & copy rows based on a keyword list
• › An Excel Macro To Find match & Copy Rows IN COLUMN
• › Need excel macro to fill the web forms
• › i need excel macro code for spliting cell data & copy