+ Reply to Thread
Results 1 to 2 of 2

Excel VBA auto filter and copy to other worksheet

  1. 08-04-2020, 02:09 PM #1
    zsolti900
    zsolti900 is offline
    Registered User
    Join Date
    02-23-2020
    Location
    England
    MS-Off Ver
    2013
    Posts
    1

    Excel VBA auto filter and copy to other worksheet

    Hi all,

    I have around 20000 row data with 6 column. I would like auto filter if cell contatin specific value from list, and copy this filtered data to worksheet2. Somebody can help me with this please?
    Thank you.
    Reply With QuoteRegister To Reply
  2. 08-04-2020, 07:19 PM #2
    maniacb
    maniacb is offline
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Excel VBA auto filter and copy to other worksheet

    Let us know if this example works for you.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by maniacb; 08-04-2020 at 07:48 PM. Reason: Corrections to response
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. EXCEL 2003 - how to auto copy from one worksheet to another
    By G.S. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2014, 10:06 PM
  2. Excel VBA Filter data and copy it to a different worksheet
    By ralucat23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2014, 05:28 PM
  3. Allow auto filter- vba protected worksheet
    By iancmiles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2013, 04:05 PM
  4. Auto filter on one worksheet has info linked from another worksheet, how do auto update
    By Diva502 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2013, 07:49 AM
  5. Auto filter data and copy results to another worksheet?
    By thisiscrazy in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-24-2012, 07:46 AM
  6. [SOLVED] Using auto filter when worksheet is protected
    By Tim in forum Excel General
    Replies: 7
    Last Post: 03-22-2006, 12:45 PM
  7. [SOLVED] Excel auto filter doesn't recoginize case - won't filter AA from A
    By Mikey in forum Excel General
    Replies: 1
    Last Post: 09-29-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1