automatic move and delete macro based on cell value

[DJSno]

I know that this may be redundant, But nothing I have found seems to quite fit.

I have a workbook that has multiple sheets. This is a sales type worksheet. I it is brand new and I have created drop down validations for the users. I want to have an entire row moved to an archive sheet once a certain value is selected from the G cells, then have the original values in the row deleted I would like the row to remain for future data input.

I have attached a copy of the workbook here for you to look at and hopefully test.

Thanks for anyones help here. I really appreciate it. I haven't done any VBA in a very long time and unfortunatley have lost it.

[Leith Ross]

Hello DJSno,

Welcome to the Forum!

Are your referring to column "G" on the "Pipeline Input" sheet? I found the worksheet DropDownData, but no validation drop downs. Which columns and which worksheet(s) should have the drop down validations?