Thanks for your input, but,

I am looking for a filter to run using the current data the way it is
i dont want to modify the original sheet. Is it not possible to filte
by row instead of column?

Thanks again
M goddar

--
mgoddar
-----------------------------------------------------------------------
mgoddard's Profile: http://www.excelforum.com/member.php...fo&userid=3606
View this thread: http://www.excelforum.com/showthread.php?threadid=55850