govindakapoor
New Member
Hi There,
I have a very tricky situation here. I want to know the VBA code for below formula
=IFERROR(VLOOKUP(M175303,'[S.xls]AssetsSMAV6'!$I$5:$U$15000,13,0),"No")
THe output of this is coming out at AF175303
The formula needs to continue until the column M has value.
Also here the VBA needs to find the Blank cell in column AF and start the formula.
In this instance the blank cell was AF175303.
The other difficulty here is next month it needs to find the blank cell in column AF and then start a new formula from there rather than M175303 so it keeps on changing as we are adding data at the bottom of the sheet every month.
It will be great if you can help me with this VBA coding.
Thanks
▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !
I have a very tricky situation here. I want to know the VBA code for below formula
=IFERROR(VLOOKUP(M175303,'[S.xls]AssetsSMAV6'!$I$5:$U$15000,13,0),"No")
THe output of this is coming out at AF175303
The formula needs to continue until the column M has value.
Also here the VBA needs to find the Blank cell in column AF and start the formula.
In this instance the blank cell was AF175303.
The other difficulty here is next month it needs to find the blank cell in column AF and then start a new formula from there rather than M175303 so it keeps on changing as we are adding data at the bottom of the sheet every month.
It will be great if you can help me with this VBA coding.
Thanks
▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !