I have an excel sheet with 2 workbooks. Its basically an action matrix. The actions list starts from row 12 (above is the header)and has 14 columns.
Starting from column A14 i have a drop down list(open/closed).
I would love to have a macro which cuts the entire row and paste it to the next empty row in my 2nd worksheet "closed", once i select the "closed" drop down.
In the same time it should delete the empty row in my 1st sheet "open"
I've been trying to do that with an command button but miserbly failed.
Am i dreaming or is there any one around who could help?????