Hi Ron I changed the code to filter on column E:E
And it seems to be working I have yet to try this in the real workbook
but I
am excited that this is going to do the trick I may need you to help
fine tune it.

When it brings the new data in and places it at the bottom I need to
Sort rows A5:M350 by column A
What code can I add that will do this?

I'm telling you I think my 3 month search for a solution to this is
almost over.
Your the greatest.

Thanks
Charles


--
mrdata
------------------------------------------------------------------------
mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899
View this thread: http://www.excelforum.com/showthread...hreadid=528779