Paste Special

[Oghale]

How to paste in a filtered column skipping the hidden cells.

[#2]

Hi @Oghale 

Copy the formula or value to the clipboard (Ctrl+C)

select the filtered column or Cells

Press Ctrl+G to open the Go To dialog box --> Click Special --> select  "Visible cells only" --> OK 

Press Ctrl+ V

This will help you copy just one value