re: Need some Excel help

You have to create a Macro.

quote:

---

Sub macroNewRow()
ActiveCell.EntireRow.Select
Selection.Copy
Selection.Insert Shift:=xlDown
End Sub

---

If your Developer Tab is not visible, add it by customizing the toolbar ribbon under "File:Options". Once you have the developer ribbon displayed, then simply click on Developer->Insert->Form Control->Button

It will popup with the list of Macros to assign to the button. Select the macro you want. The one I have above basically copies the active row and inserts it directly below. So basically, each new row is an exact duplicate of whatever row is currently active.

You can dress this up by specifying the active range to copy from -- that way instead of relying on the user to have the "right row" highlighted, it always copies the same row and inserts it into the same place in the sheet.