Paste Special

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