ExcelBanter - Copy data to filtered column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copy data to filtered column (https://www.excelbanter.com/excel-discussion-misc-queries/136853-copy-data-filtered-column.html)

Arif Ender

Copy data to filtered column

Hello,

I am using Office 2007 and in Excel 2007 I have a problem which I
didn't ever had with 2003 version.

When I try to copy a data block from a worksheet to another one which
is a filtered column, it doesn't replace the filtered values, it just
replaces all the values.

How can I do that?

All times are GMT +1. The time now is 06:39 AM.