This macro/code works perfect, I need it to continue to do exactly what it is doing except to insert the new row(s) below where the user clicks.
I could have a sheet where there is data like this:
A Patient 1
B Test1
C Test 2
D Test 3
E Test 4
F Patient 2
G Test 1
H Test 2
And I need to add a Test 5, 6, 7 to Patient 1 after test 4.
Right now it would add them above test 4 if user clicked cell E4 for the insertion point.
And I cant select cell F1 because the patient line is always going to be formatted a different color and font and stuff and I can't have it pull that formatting for test lines.
Here is the code
HTML Code:
Bookmarks