Conditional Macro for moving data

[imgr8]

Hi,

I took this macro from a topic in this forum and it works fine for moving rows from one sheet to another if the value changes to "Proposal" in column E. However, I would like to add other values in the column too such as "On Hold" and "Lost" and then move the respective rows to the respective sheets of On Hold and Lost once the macro is activated. I am assuming that it will have to be a conditional macro. Can this code be modified to do the required:

Please Login or Register  to view this content.

[rylo]

Hi

Try this. It assumes that the output sheet names are the same as the value in column E.

Please Login or Register  to view this content.

Also, can you please read and adhere to the rules regarding cross posting. I gather that you also posted on Ozgrid, but that entry has since been deleted. There is also a posting on Mrexcel.

rylo