Copy filtered table columns in VB

Question

Copy filtered table columns in VB

[Closed]

Report

Greg - Apr 15, 2010 at 02:02 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

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

Copy filtered table columns in VB
Vba search table column for value - How-To - Excel
Html table column width: auto adjust - How-To - HTML
How to delete table column in word - How-To - Word
Excel data validation list from table multiple columns - How-To - Excel
How to add year filter in pivot table - How-To - Excel

2 replies

Ask a question

venkat1926 · Answer 1 · 2010-04-15T07:23:37-0400

Answer 1 / 2

venkat1926

Posts: 1864
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: August 7, 2021

802
Apr 15, 2010 at 07:23 AM

use the proerty
specialcells(xlcelltypevisible)

see help under specialcells in vba help

rizvisa1 · Answer 2 · 2010-04-15T07:23:43-0400

Answer 2 / 2

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

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

Copy filtered table columns in VB

2 replies

Your reply

Subscribe To Our Newsletter!