copying one column with hidden/filtered rows to another colum

  • Thread starter Thread starter Rechie
  • Start date Start date
R

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
 
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.
 
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.
 
Back
Top