Creating userform to duplicate rows based on counter which defines iterations

Dear Experts,

Firstly thanks for all your lovely assistance to the world. This help means a lot to us .
In this project , if any of you get the time to attend , i need a macro which duplicates row entries !

Please see the attached sheet which contains 2 tabs Input and output ....
The output duplicates row entries for every individual entry in column J

For example here , for each entry in column J , if you see output tab i am duplicating it 10 times ...however i have a dded column J which shows me the counter and column K containing the field names ...in fact there were more columns which deleted ....i wish that the macro leaves the other columns untouched and just inserts one new column J which helps me to know the row counter

i would love the macro to give me a userform with some kind of a index file to launch the macro from. This is so that i can run the macro on multiple files where i want to run similar operations without having to copy the VB code from file to file...i can simply browse the file and specify the number of times i want to duplicate rows based on value in Column J of INPUT tab

The idea of a index file which gives me a user form to specify row iterations can be seen in this link where David sir was gracious to offer me such a solution which i was really not aware of earlier -http://www.excelforum.com/excel-programming-vba-macros/1038939-create-new-file-based-on-first-100-rows.html#post3847861


Coming back to the project, using the user form if i had specified row counter to say 100 entries , then each entry in column J would get duplicated 100 times ...while duplicating , i want the complete row to be be taken with all columns in complete along with color code because the color has a purpose ...with the addition of a extra column which shows the row counter

Note , that the total number of rows can be arrived at by seeing cell A1 which will contain value "END" denoting the end of entries .So , we can first count total number of rows based on this parameter before then deciding to duplicate the rows based on column J entries !

I would be so happy if someone could help me ...the project if developed would help me make knowledge in some subjects free !

Cheers ,

Amlan Dutta

Dear David ,

I cannot even express how much happy i am to see you again take up the project ....you are a living legend ...Thanks so so much for taking this project up.....
I did try working with the file but unfortunately i could not get it working ...though when i opened up the VB module , i could see that you have defined a user form, but when i open the sheet , there is no user form to like run the source file !
I think maybe there is some small thing happening which i am unable to understand ,

If you can look into it , i will be so happy ...nevertheless thanks a tonne for picking this one up !

Cheers ,

Amlan

Dear David ,

The userform defined in the macro doesn't show up in the sheet ...am i like doing something wrong ....am so sorry to give you pain

Humble regards ,

Amlan Dutta

Dear David ,

You are the sweetest thing that god can create! I am so happy that he made you ...there was indeed a tools button like you said and when i clicked on it the user from did come up and rest like you understand was magic unweaved the way you wrote it!
Since i use excel 2007 , the 2003 button didn't work but trust me , that is not needed because with the tools itself i am able to achieve what i want ...one thing that i further loved is that even the formatting is retained in the output Tab's ...that is a added bonus .
I have marked the thread as solved and obviously given you credits ...i wish i could have done more ...you are a true masterpiece ...now my dream of making a question bank has got a shot in the arm thanks to your lovely magic !

Thank you so so so so so so so muchhhhhhh!