I am trying to create a macro for a project management sheet in
excel. I have a column that has a drop down validation; when
"Cancel"
is selected, I would like the entire row to be moved to "Sheet2" in
the workbook. I want this to work for all of the projects (each
listed on a different row). I do not have that much experience with
macros, so detailed instructions will be grately appreciated :)