Hi,

Does anybody know what to use say if I want a particular row to be transferred to another sheet in the same worksheet if the condition in one column is met?

Say I have Columns A-E then under column D there are lists labeled as "new, old and upgraded". I've been trying to work out on something but couldn't get the best solution. I don't want to delete the content in my sheet 1, I just want the segregate contents to be shown in different sheets without me having to copy and paste every now and then after filtering.

Thank you in advance.