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...
  • Miscellaneous Exercise 2
    'Check filter is applied on the sheet or not if not apply filter on it Sub autofilteron() Sheet3.Activate If Not ActiveSheet.AutoFi...
  • WorkSheet
    'Worksheet Object 'Represents a worksheet. 'Remarks ' ' 'The Worksheet object is a member of the Worksheets co...