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.

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
0
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.
0