I am putting together a form which my staff will fill in various data fields. From those datafields on what I will call "Sheet1", they are automatically filled in at specific fields in "Sheet2" in just one row.

What I am trying to do, is that on "Sheet1", I want users to input to input an "x" or whatever to state that they are done, and when that happens, the box on "Sheet2" goes down to the next row. For example. If it ends on A20 in "Sheet2", when a user inputs an "x" on "Sheet1" to indicate they are done, I want the box selected on A20 to go down to B1.

I already ran this in my mind and it sounds as if it would just be a loop. I can't think of any other way to do it.

I can't just have my staff fill out each row with the information, as I am afraid they will erase over it, have troubles, etc. Having a nicely formated, color coded form to fill it out, then having the information dumped onto a data sheet is preferred. I just need an easy way for it to go to the next row on "Sheet2" once it's complete.