Hi,
Once filtered, select all the data, then do CTRL G, Special, visible cell
only, OK, then CTRL C, then paste it where you need the information.

if this helps please click yes, thanks

"Tina" wrote:

When I filter the data and copy to another location, ALL the data is
displayed, not just the filtered data