sorting and locking rows

Originally Posted by DanMnz

Yes, thank you, that answer does help me.

"non-contiguous columns" is where the problem is. Thought I could find a way around that, but I guess I cannot.

Thank you.

If the book is reasonably stable you could use some VBA code on a 'Worksheet_Change' trigger to test and remove any criteria that had been applied to Criteria1 or Criteria5 such as for

Selection.AutoFilter Field:=1, Criteria1:="Monday"
you would clear by using
Selection.AutoFilter Field:=1
but if you are not versed in VB then this could be fraught with danger.

---

Originally Posted by DanMnz

I'm great in visual basic 6, but never tried to use it with excel. I'll look into that. thank you.

ok - try Tools, Record New Macro, and perform any function that you require to give you the basics of VBA code for that process, it's a good start (the Help is ok for supplying parameters if you know what you want to do, but pretty ordinary as a learning tool)

http://www.excelforum.com/showthread.php?t=584092 has links to useful reading for all stages of development.

---