ok thanks ill try that.

had an idea about the sorting, how about using autofilter once t
filter out the whole list instead of particular rows, then sort thi
filtered list somehow, then do autofilter again on the newly sorte
list?

problem with sorting the list is because the data needs to remain i
the same tables, doing a Data/Sort on it actually moves the data aroun
so that its all in the wrong tables when you take the filtering off.

ill leave the sorting if its not that easy as its not really hugel
important

--
Message posted from http://www.ExcelForum.com