Hi all, i would like to create a VBA code so that to run through row "1" and where find the text "Bank list' should create the below formula:
"=VLOOKUP(RC[-10],'[PAYMENT LIST.xlsx]Sheet1'!R4C1:R5000C32,25,0)"
Kindly note that the formula should begin from row "2" till last fulfill row based on col. "K".
Below is an extract of my spreadsheet in which i want to add the above formula below Bank list column.
Thanking you in advance
<colgroup><col style="mso-width-source:userset;mso-width-alt:2389;width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:2844;width:60pt" width="80"> <col style="mso-width-source:userset;mso-width-alt:4380; width:92pt" width="123" span="2"> </colgroup><tbody>
</tbody>
"=VLOOKUP(RC[-10],'[PAYMENT LIST.xlsx]Sheet1'!R4C1:R5000C32,25,0)"
Kindly note that the formula should begin from row "2" till last fulfill row based on col. "K".
Below is an extract of my spreadsheet in which i want to add the above formula below Bank list column.
Thanking you in advance
K | L | M | |
1 | CODE | Bank list | Variance |
2 | 2002 | ||
3 | 2008 | | |
4 | 2010 | | |
5 | 2011 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:2389;width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:2844;width:60pt" width="80"> <col style="mso-width-source:userset;mso-width-alt:4380; width:92pt" width="123" span="2"> </colgroup><tbody>
</tbody>