Results 1 to 10 of 17

Thread: Exclude Contents From List :

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 06-07-2013, 08:54 PM #13
    snb
    snb is offline
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    @Rick

    snb_004 puts the items to be removed in a criterion range D1:F2
    It's necessary that column A has a column label/ heading in A1 which doesn't appear in the list A2:A10000
    The advancedfilter will write the result into column M.
    Attached Files Attached Files
    Last edited by snb; 06-07-2013 at 08:58 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Macro for copying the contents of a cell to the Windows clipboard
    By isabelle r in forum Excel Help
    Replies: 5
    Last Post: 01-12-2013, 02:49 AM
  2. Delete List Contain Matching from Second List
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 12
    Last Post: 10-07-2012, 07:18 PM
  3. Macro for Opening files and copy the contents of the File
    By ravichandavar in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 09:17 PM
  4. Macro to create files as per the contents in a column
    By Praveen Bj in forum Excel Help
    Replies: 1
    Last Post: 07-05-2012, 09:07 PM
  5. clearing contents of array of ranges using a single line of code
    By Junoon in forum Excel Help
    Replies: 4
    Last Post: 05-14-2012, 11:58 AM

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