Wednesday, March 15, 2017

How to Filter the data

Data type Risk Type Country Operation  terms
Internal People IN Notes to Accounts
External System CN Onbalance sheet
Internal Natural UK Notes to Accounts
External Partner US Onbalance sheet
Internal Location BR Notes to Accounts
External People HK Onbalance sheet
Internal System JP Notes to Accounts
External Natural ME Onbalance sheet
Internal Partner AE Notes to Accounts
External Location UE Onbalance sheet
Internal People AR Notes to Accounts
External System IN Onbalance sheet
Internal Natural CN Notes to Accounts
External Partner UK Onbalance sheet

Sub filter_test()
               
        Range("A1:D1").AutoFilter field:=3, Criteria1:="IN"

End Sub
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

*INTERVIEW QUESTIONS

* Ques 01. What is the difference between ByVal and ByRef and which is default ? Ans-  ByRef : If you pass an argument by reference when...

  • Text File
    ''TextStream Object ' 'Description ' 'Facilitates sequential access to file. ' 'Syntax ' 'T...
  • Object Variable
    'Object variable not set (Error 91) ' 'There are two steps to creating an object variable. First you must declare the object ...
  • File System Object
    'FileSystemObject Object ' 'Description ' 'Provides access to a computer's file system. ' 'Syntax ...