• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA for Vlookup from Multiple workbooks

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 !
 
Back
Top