I have a workbook that I list issues. On the first worksheet, I have a column called Resolution, and all resolutions are set to General for all issues. What I require is, when I change the resolution of an issue, I would like that entire row to be moved to a new worksheet.
I have looked at other posts like: http://www.ozgrid.com/forum/showthread.php?t=148170
I have 5 Resolutions; Completed, In Dev, Pending, Postponed and By Design. Using the Code from the above link works perfectly for the Resolution Completed. How do I rework the code in the link above to include the other resolutions. I have tried and finally gave up.
Please help if possible.