How to identify new rows to add data to them

I need to fill rows with data from excel.

The data in drop down gets autofilled according to the company selected.



What property of the cell can I choose to select the next after each row is filled.



As you can see in the attachment the for the cell with name I tried using the property index of the first value in the cell i.e "0" which in the attachment is "Nikesh Arora" ..this works fine as long as the user has not added a row with details of "Nikesh Arora"..Bcos my script searchs for the cell with index "0" to fill next row from excel.





thanks in advance