Move Row to Bottom of 2nd worksheet then delete from sheet 1

[mlcollins]

Hi all -

I have played around with what I have been able to find on this forum and even asked my brother (who programs Java) and am stuck! I have NO programming experience and have used what you all have given on other threads but still can't seem to get it to work for me.

I have a workbook that has three sheets (PE, RT, CE) and multiple columns. I have inserted a drop down list (using data validation) in Column A. I want to choose RT or CE from the list then have the row, from Column B to the end of the sheet, move to the next blank line in the corresponding sheet. For example, Row 4 - when I choose CE from the drop list will move, from Column B to the end of the Row, to the next blank line in sheet CE. It will paste into Row B to the end because I column A in RT and CE is a date field.

I want the contents in sheet PE to be cleared BUT not deleted because I don't want to keep inserting the drop down list in column A.
HELP PLEASE!

I have attached (I hope) a test workbook I have been using.

THANK YOU THANK YOU THANK YOU!!

[sintek]

Hi mlcollins

Welcome to the forum....
In order for us to assist with the correct code, please explain the following.
Must it happen instantaneously as selection is made or do you wanna press a button?
Will there be multiple instances of each?

Try this....Put code in a std module and run after selecting from dropdown list

Please Login or Register  to view this content.

[jindon]

To a sheet code module

Please Login or Register  to view this content.

[mlcollins]

Okay - so close but not complete .... How do I get the ENTIRE row to copy? So far it is only copying/clearing contents for some of the cells not the entire row

[sintek]

Your upload only had 4 columns?

[mlcollins]

It did. I figured out how to adjust the number of cells across. Now I can't filter on Sheet 1 (PE) after the "clear contents" command. Any ideas? Is there a way to Delete the row after moving the data instead of clearing the contents or move the remaining data up?

*****I figured out how to modify the code. Problem solved. Thank you

[sintek]

Deleted...
OP figured it out...