Copy filtered table columns in VB

Closed
Greg - Apr 15, 2010 at 02:02 AM
rizvisa1
Posts
4479
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 replies

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

see help under specialcells in vba help
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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