Feb 07 2022 03:48 PM
How to paste in a filtered column skipping the hidden cells.
Feb 07 2022 10:10 PM
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