Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Public Function II_WAY_LOOKUP(Lookup_Value As Variant, Reference_Column As Range, Result_Column As Range) II_WAY_LOOKUP = WorksheetFunction.Index(Result_Column, WorksheetFunction.Match(Lookup_Value, Reference_Column, 0), 1) End Function
|i'm trying to create pivot table using source data using macro script which i recorded and given below. when i run it i'm getting debug error. could anyone help to fix this issue||10||27|
|VBA Challenge how to code to loop through all files in folder and revise some part of the codes||15||34|
|Unhide very hidden sheets with password||22||44|
|How to transform one row line like this in excel table 2010?||22||18|