copy-paste filtered data...

[gledister]

It happens that when I filter data by a column value and when I want to copy that "remained" part of a column in one other sheet....it takes me even the "hidden" datas by filtering...

How can I do to avoid that?!

Kind regards.

Thanks in advance!

 

[VoG]

Select the data, press F5, click Special, tick Visible Cells Only then click OK. Then copy.

 

[gledister]

thank you very much!