I have a list/s of names and details and i would like to automatically update the list on to new sheets after the criteria has changed.

So for example, if opened = No, i'd like the row/s and column's of data to automatically update onto a new sheet, Column A = Name, Column B = Date, Column C = Details Required, Column D = Opened.

I've tried Vlookup but can only get one piece of data across, so i thought i'd bow to your greater knowledge. If you can help that would be great and also if you need to ask me any questions for more details i'll gladly answer, if i can!

Thanks

Ian