Copy filtered table columns in VB

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
On change of cell content in Sheet2:A1 from defined list, I want to filter a table in Sheet 1 and then copy the contents of a column from the filtered table to a location on sheet 2. I can filter the table with OnChange but cannot get a copy / paste with range to respond.

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
use the proerty
specialcells(xlcelltypevisible)

see help under specialcells in vba help
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link.