Excel 2007 Autofilter vs Excel 2003

[James8309]

Hi everyone

I am a excel2003 user and when I just do a autofilter and copy & paste
result to a new sheet, it will only copy the data that I ve already
filtered but how come in excel 2007 it does not allow me to do that?

e.g. If I have a data from column A to G and do a autofilter from
A1toG1 and when I filter column B by "ABC" , select and copy the
filtered results. In;
Excel2003: It only copies that is "ABC" in column B.
Excel2007: It copies the whole thing.

Can anyone help?

thanks for your help in advance

Regards


james

 

[OssieMac]

This question has arisen before. Ron De Bruin (MVP) has said that it appears
to be a bug that raises its ugly head intermittently including in earlier
versions. It is possible that you could close Excel and reopen it and it does
what you expect. At the moment, I cannot reproduce the error in xl2007 but I
have experienced the problem on previous occasions.

Anyway, I have found that if I select the cells then click Find & Select->
Goto Special->Visible Cells only then it appears to overcome the problem.

As someone wrote in the forum previously, you can tell whether it has
selected the visible cells only by the "Crawling Ants". If they are only
around the perimeter then it has selected all but if they are between the
lines also then only visible cells are selected.

 

[James8309]

This question has arisen before. Ron De Bruin (MVP) has said that it appears
to be a bug that raises its ugly head intermittently including in earlier
versions. It is possible that you could close Excel and reopen it and it does
what you expect. At the moment, I cannot reproduce the error in xl2007 but I
have experienced the problem on previous occasions.

Anyway, I have found that if I select the cells then click Find & Select->
Goto Special->Visible Cells only then it appears to overcome the problem.

As someone wrote in the forum previously, you can tell whether it has
selected the visible cells only by the "Crawling Ants". If they are only
around the perimeter then it has selected all but if they are between the
lines also then only visible cells are selected.

--
Regards,

OssieMac









- Show quoted text -

Thanks alot for your help