Moving rows to another worksheet once cell value entered

Normally I and I imagine a lot of other contributors to this board would not respond to a post that does not have a sample workbook. There is work involved in duplicating a workbook that you may already have. So, in the future, include a sample workbook and people will be more likely to respond.

In this case, the setup was not all that difficult. You WILL have to modify the code to suit your needs. Very often with a sample workbook, you can run the code as is.

Put the following code on the Sheet Module for the sheet you have Column AE on.

Please Login or Register  to view this content.

You do not need a button. As soon as yes (case does not matter) is entered in Column AE, the code will run.

One minor quirk is how LRow is calculated. It does not matter whether there is data on row 1 or row 1 is blank. The LRow will think that the last row with data is row 1. Since we want to add data to the next available row, we add 1. This means that the program enters data starting on row 2. The rest of the rows calculate properly.

Since you probably have a header row in the first row of the destination sheet, this is probably what you do want.