Automatically going to next line on sheet...

[dllivermore]

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.

[Leith Ross]

Hello dllivermore,

Welcome to the Forum!

To better illustrate your problem, you should post your workbook. It will make clear what you are referring to in your post. You should also include before and after examples of the data and comments about results you expect.

If your workbook contains sensitive or confidential information, please be sure to change the names of people, phone numbers, and businesses before posting it.

[dllivermore]

Now that I play with it I may be asking for the impossible, but I can try anyways.

Attached is a condensed version of what I am working with. Info is typed into sheet 1, and is copied onto sheet 2, with the goal being a long list of data to work with and review.

I think I need more than what I am thinking. As if it goes to a new line or adds a new line, the formulas need to adjust to allow information to be typed into that new line. I am unsure if I am explaining what I want correctly, so maybe someone can help.

Hello dllivermore,

Welcome to the Forum!

To better illustrate your problem, you should post your workbook. It will make clear what you are referring to in your post. You should also include before and after examples of the data and comments about results you expect.

If your workbook contains sensitive or confidential information, please be sure to change the names of people, phone numbers, and businesses before posting it.

[Leith Ross]

Hello ,

Here is the macro that has been added to the attached workbook. If an "X" (case is ignored) is entered into D9 then the data is transferred to the next available line on "Sheet2".

Please Login or Register  to view this content.

[dllivermore]

That's perfect, thank you so much!

Hello ,

Here is the macro that has been added to the attached workbook. If an "X" (case is ignored) is entered into D9 then the data is transferred to the next available line on "Sheet2".

Please Login or Register  to view this content.