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