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.

Copy filtered table columns in VB
School time table software free download full version - Download - Organisation and teamwork
Excel data validation list from table multiple columns - Guide
Vb editor download - Download - IDE
Html table size to fit window - Guide
How to delete line in table in word - Guide

2 responses

Answer 1 / 2

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

Answer 2 / 2

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.

Similar discussions

Comparing columns and returning value

Similar discussions

Subscribe To Our Newsletter!