+ Reply to Thread
Results 1 to 4 of 4

Filter Wksht2.ColumnA on Values from Wksht1.ColumnA

  1. 05-12-2014, 04:01 PM #1
    athyeh
    athyeh is offline
    Registered User
    Join Date
    06-12-2013
    Location
    Rochester, Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    80

    Filter Wksht2.ColumnA on Values from Wksht1.ColumnA

    Hi Folks,

    Looking for some VBA code on how to filter Wksht2.Column A for all values found in Wksht1.ColumnA?

    Thanks for all your help.
    Reply With QuoteRegister To Reply
  2. 05-12-2014, 04:07 PM #2
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Filter Wksht2.ColumnA on Values from Wksht1.ColumnA

    can you post a sample workbook?
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
  3. 05-12-2014, 04:16 PM #3
    athyeh
    athyeh is offline
    Registered User
    Join Date
    06-12-2013
    Location
    Rochester, Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    80

    Re: Filter Wksht2.ColumnA on Values from Wksht1.ColumnA

    Another note: Wksht1 will be in Wrkbk1 and Wksht2 will be in Wrkbk2, thank you for your all your help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 05-12-2014, 04:46 PM #4
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Filter Wksht2.ColumnA on Values from Wksht1.ColumnA

    try this 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    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. Fill comboBox wih the values of columnA
    By sugee in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-03-2013, 05:25 AM
  2. conditionally copy formulas and paste their values based on columnA
    By cmmchick in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-29-2013, 05:02 AM
  3. [SOLVED] Find value X in columnA and paste entire row above value Y in columnA
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-27-2012, 06:25 AM
  4. Matching values in Sheet1 ColumnA from values in SHeet 2 ColumnA
    By hood8jmark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2008, 06:50 PM
  5. Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA
    By Master in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-06-2005, 03: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