Vba to fill vlookup formula until the end of used row

[yllew]

i have tried to make a code to fill a column with vlookup formula but it doesn't fill until end of the used row. i am not very good in coding, hope any expert here can help to correct my code.
The steps i am trying to do is:
1) In "working file.xlsm" copy the raw data from another workbook "Raw.xls" into "Sheet1"
2) fill in column H by vlookup formula from sheet "Mst"
I placed my command button at sheet "Mst".

Please Login or Register  to view this content.

[SjonR]

the row counting happens on the wrong sheet:

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Or this:

Please Login or Register  to view this content.

BSB

[mjr veverka]

Another variant:

Please Login or Register  to view this content.

[yllew]

I got it. Thanks all for helping me! I really appreciate your help!