copying one column with hidden/filtered rows to another colum

[Rechie]

How can I copy column with hidden rows/filterd into another column with
visible rows only to be exactly paste in another column.

Thanks

 

[Luke M]

After selected the column with fitlered rows, press Ctrl+G to bring up the
GoTo dialogue. Click special, then choose "Visible Cells Only". Copy these
cells, and then paste.

 

[Rechie]

Thanks, sorry I forgot to mentioned that the target column has data in the
hidden rows. Is it possible that it will not be replaced from the source data
(data in copy from column) ?

Thanks again.