Copy filtered column of ListObject to another ListObject

**snapfade** · 09-15-2016, 01:29 PM

Hi,

I have two tables (ListObjects), each on a different worksheet of the same workbook. I have filtered ListObject1 and now want to copy the data in Column E to ListObject2, Column A. ListObject2 has only the header row, no data.

Bump: I am attaching a spreadsheet to better illustrate.

I have tried all sorts of solutions but nothing seems to work. Your assistance would be most appreciated.

tom

**walruseggman** · 09-15-2016, 03:30 PM

You said copy column E, but your sample shows column F. Assumed the latter.

Please Login or Register  to view this content.

**snapfade** · 09-15-2016, 03:47 PM

Hi Walruseggman,

Thanks for posting. I tried your code, customized to my app and got Application-defined or object-defined error. Here's the exact code:

Please Login or Register  to view this content.

Did I do something wrong?

**walruseggman** · 09-15-2016, 03:54 PM

If your tables are on different sheets you need to reference them like

Please Login or Register  to view this content.

**snapfade** · 09-15-2016, 04:00 PM

Wow! Worked like a charm! I shoulda posted here a few hours earlier.

Thanks ever so much, Walruseggman.

tom

Copy filtered column of ListObject to another ListObject

LinkBack

Thread Tools

Rate This Thread

Display

Copy filtered column of ListObject to another ListObject

Re: Copy filtered column of ListObject to another ListObject

Re: Copy filtered column of ListObject to another ListObject

Re: Copy filtered column of ListObject to another ListObject

Re: Copy filtered column of ListObject to another ListObject

Thread Information

Users Browsing this Thread

Similar Threads

Rearrange Table Column (i.e. ListObject.ListColumns...)

[SOLVED] Get Visible range from UDF passed filtered Listobject columns as argument

Looping thru a filtered Listobject

ListObject Total Each Column

Use of ListObject

ListObject

ListObject Name ?

Bookmarks

Bookmarks

Posting Permissions