Hi, having trouble using the copy to another location option within advanced
filtering. i am trying to extract multiple rows that contain the company
name specified as my criteria. when i filter it in place it works but when i
try and copy it to another worksheet i get the error message " you can only
copy filtered data to the active sheet" Any one got any ideas what i am doing
wrong?? Thanks