Renumbering Row based on answer in txtbx in VBA

[kmowers07]

I have a user form that i enter data into that puts that data on the last row of the table.
it looks at the previous row that has the PL Name and provides the last used IT Unique Number that corresponds with it.
So example Row 40 PL Name "Jane" has IT Unique Number of 40. The new record PL Name "Jane" at the bottom of the table will have a IT Unique Number of 41. Going back up into the table i need to renumber every row after the previous record to be 42,43,44 and so on. I have read about the ROW function but i am confused with it.
I will not know the number that will it will start with because it will be based on the newITUniqueNumber

 

[kmowers07]

I have a user form that i enter data into that puts that data on the last row of the table.
it looks at the previous row that has the PL Name and provides the last used IT Unique Number that corresponds with it.
So example Row 40 PL Name "Jane" has IT Unique Number of 40. The new record PL Name "Jane" at the bottom of the table will have a IT Unique Number of 41. Going back up into the table i need to renumber every row after the previous record to be 42,43,44 and so on. I have read about the ROW function but i am confused with it.
I will not know the number that will it will start with because it will be based on the newITUniqueNumber

Book1
	A	B
1	IT Unique	PL Name
2	36	Jane
3	37	Jane
4	38	Jane
5	39	Jane
6	40	Jane
7	41	Doe
8	42	Doe
9	43	Doe
10	44	Doe
11	45	Doe
12	46	Doe
13	41	Jane
Sheet1