copying one column with hidden/filtered rows to another colum
 

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

Thanks

copying one column with hidden/filtered rows to another colum
 

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

copying one column with hidden/filtered rows to another colum
 

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.

"Luke M" wrote:

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