dss28
Board Regular
 Joined
 Sep 3, 2020
 Messages
 61
 Office Version

 2007
 Platform

 Windows
I am using Index match function in excel to retrieve values from a sheet ("MasterData") to another sheet ("Report") using a specific unique number which the user enters in a cell in sheet "Report" . This populates a table with about 6 columns and 15 rows as per the data available in "MasterSheet" for that particular unique number.
for this I have entered this formula in each of the cells in sheet "Report" in the 15x6 rows/ column table.
formula is :
{=INDEX(MasterData!C:C,MATCH($E$7&""&$C$14,MasterData!F:F&""&MasterData!H:H,0))}
In this formula the cell reference $E$7 and $C$14 is in sheet "Report".
The user enters the specific unique code in cell C14 which then matches the values of each row reference cell E7 to pull the corresponding values in the table on this sheet.
Now I want to convert this formula to vba code.
can any body help me to convert this in vba code:
for this I have entered this formula in each of the cells in sheet "Report" in the 15x6 rows/ column table.
formula is :
{=INDEX(MasterData!C:C,MATCH($E$7&""&$C$14,MasterData!F:F&""&MasterData!H:H,0))}
In this formula the cell reference $E$7 and $C$14 is in sheet "Report".
The user enters the specific unique code in cell C14 which then matches the values of each row reference cell E7 to pull the corresponding values in the table on this sheet.
Now I want to convert this formula to vba code.
can any body help me to convert this in vba code: