Need Macro to move data from one worksheet to another

I've been browsing the forum most of the day searching for macros that fit the problem I am trying to accomplish. A few have been close or I haven't been able to figure out how to apply them.

I am trying to set up a workbook to act sort of like a cheap Access for users that are comfortable with Excel. They need to be able to enter data into the "Study Leads" worksheet but based on the final column "a trigger" that selection moves the data to a different worksheet and deletes it from the "Study Leads" sheet.

The functionality would need to work on all worksheets other than the last worksheet labeled "declined", as the other worksheets are stages of enrollment.

I have attached the basic workbook I created so it has a clean slate for macroing with a line of test data.

Any help is much appreciated as I can't seem to not grasp what I've found on the forum already.

Put this in each worksheet change event. Should allow you to move rows between sheets when you choose a different trigger:

Please Login or Register  to view this content.

In your example the data validation isn't set up for any rows other than the first one. Did you check to make sure that it is set up on your primary workbook?

I'm looking and testing now. I see that when a trigger is activated it deletes the row and moves them up. So once I have set up validation for a specific number of cells it will eventually run out. I guess I just need to set up where the validation cells are infinite. The script still works as intended.