Excel 2007 Autofilter vs Excel 2003

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
Wed Jul 23 20:59:00 CDT 2008

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


"James8309" wrote:

> 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
>

James8309
Wed Jul 23 21:52:35 CDT 2008

On Jul 24, 11:59=A0am, OssieMac <Ossie...@discussions.microsoft.com>
wrote:
> This question has arisen before. Ron De Bruin (MVP) has said that it appe=
ars
> 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 bu=
t 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
>
>
>
> "James8309" wrote:
> > 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- Hide quoted text -
>
> - Show quoted text -

Thanks alot for your help:D