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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Rechie" wrote:

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

Thanks