Copy filtered table columns in VB

Closed
Greg - Apr 15, 2010 at 02:02 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 15, 2010 at 07:23 AM
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.

Related:

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Apr 15, 2010 at 07:23 AM
use the proerty
specialcells(xlcelltypevisible)

see help under specialcells in vba help
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 15, 2010 at 07:23 AM
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link.