Excel 2007 - Filtering and copying
 

In the 2003 version I have at work I can filter a column, then drag copy
information and it will only copy into the filtered cells. When I try to do
this in 2007 it copies into all cells even the ones that are hidden by the
filter. Is there a setting 2007 that will prevent this?
--
Never give up, the answer IS out there, it just takes a while to find it
sometimes!