Insert Row button

[ERcoder]

Hello all,
On our list of patients the staff goes through and enters the MD and charges (CPT) for each patient in the spreadsheet.

Can I add a button or link or something in column H that they can click to add a row below their current row for patients that have more than one charge?

As an added complication the MD# column has a vlookup formula to find the number when they enter the Dr name.

You guys are great help. I signed up for a Excel class at the Vo-tech so I hoepfully I can quit buggin you guys.

 

[Desu Nota from Columbus]

You can use this to input a row below the active cell:

Sub insertrow()
ActiveCell.Select
Selection.Offset(1, 0).EntireRow.Insert
End Sub

Just insert a command button and assign this macro to it.

Can you post your Vlookup formula so I can add it to the macro?