Exporting filtered data to .CSV

[Daniel Westerdale]

hi

I want to quickly export only the visible data in a filtered Excel 2016 view to a  .CSV  file .  This is proving quite tricky as I seem to keep picking up the other rows.    Any advice please.

[#2]

Copy the filtered data to a new workbook and paste as values.  This should only paste the visible cells.  Save the new workbook in csv format.