+ Reply to Thread
Results 1 to 2 of 2

VBA: Filtering By Copied Value

  1. #1
    Registered User
    Join Date
    03-23-2014
    Location
    KSA
    MS-Off Ver
    Excel 2007
    Posts
    1

    VBA: Filtering By Copied Value

    Dear All
    How can i filtering the data by copied value?

    Exampel:

    Sub Cuts_Det()
    '
    ' Cuts_Det Macro
    '
    ' Keyboard Shortcut: Ctrl+q
    '
    Selection.Copy
    Sheets("Cust. Details").Select
    ActiveWindow.LargeScroll ToRight:=-1
    ActiveSheet.Range("$A$5:$T$10000").AutoFilter Field:=3, Criteria1:="=211", _
    Operator:=xlAnd
    End Sub


    i need to replace "211" by any copied value later.

    Many thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: VBA: Filtering By Copied Value

    Hi

    You'll need to access the clipboard data

    http://stackoverflow.com/questions/9...mpty-clipboard

    this should help.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help filtering data by filtering based on the last digit of a column/true statement
    By Stephen R in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2014, 07:43 AM
  2. [SOLVED] Easy filtering method via vba/formula/advanced filtering?
    By jedemeyer1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2014, 12:35 AM
  3. [SOLVED] When data is copied to another workbook, hyperlinks as not copied or they don't work
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-17-2014, 06:46 AM
  4. Copying multiple worksheet so that copied hyperlinks link to new copied sheets
    By chrisjames25 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2013, 02:37 PM
  5. [SOLVED] trouble filtering a list. Why isn't column filtering?-number of criteria
    By Pat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1