Data going to last row, is it due to colour coding?
In one of my projects, I have color coded all the rows (until 50), and locked the first row with some information. Whenever the form is submitted within that sheet, the data is supposed to it should go to second row and then following basis. However, now when I submit the form it going to 51st row and the row is automatically colour coded as the previous one. My question is why it is going to 51st row, but not in the second row? Can someone please help me find answer for this?