Macro to repeat rows in the same excel

[m.hamadeh]

I made a template for me engineer to report installation status, sometimes they do single installation other times multiple installations is happening.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
The template contains the following row, some field with preselected dropdown lists.<o></o>
<o></o>
Customer Name, Address, status, follow up<o></o>
<o></o>
I need to create a button next to the row, pressing the button will insert a new row after the original row with the same fields for the next customer to report multiple installations.<o></o>
<o></o>
Please help me the VP needed.<o></o>

 

[Yahya]

Salam m.hamadeh
Did you mean add row Under Active Cell

 

[nightcrawler23]

Sub Macro1()
Dim myRow As Integer
myRow = Selection.Row
    Rows(myRow).Copy
    Rows(myRow + 1).Select
    ActiveSheet.Paste
End Sub

put this in a module.
Inset a command button(form control) and attach this macro to it.
The code shouild retain any dropdowns that you want to keep.

 

[m.hamadeh]

The macro worked. However I have to select the row before is there a way to pre-fix the needed range in the macro (the data needed to be copied located within A10:U11).<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Also my template is containing data after the (installation row) I don’t need the data to be over written; only I need to insert.

 

[m.hamadeh]

Salam m.hamadeh
Did you mean add row Under Active Cell

not the active cell, but a pre-fixed row.