Move Row to Another Sheet Based on Dropdown Value

[kim.wo]

HI there,

I am trying to move a row from the Active to Archive folder depending on the drop down in column A in the active worksheet. When 'NO' is chosen I want the row to be copied and pasted into PO Archive and then removed so the other rows move up.

I have been reading through some of the forum but it seems it has to be done in VBA. I know nothing about VBA so please I need some help!

Thanks,
Kimberly

[Mumps1]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your "PO Active" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make your selection in the drop down in column A.

Please Login or Register  to view this content.

[kim.wo]

Thanks so much! That works perfectly.. only one little thing.. I have a couple of formulas which now show a #ref error, which is probably because the data moved across worksheets. Is there any way to keep this from happening or do I have to change all my formulas?

Thanks, Kimberly

[Mumps1]

Try this version:

Please Login or Register  to view this content.