Macro to Replace Cell with VLOOKUP

Hi I'm very new at using Macros I only know to record them not to write them but recording this one didn't seem to work quite right.

I'm trying to do the following:

Replace the value of Column 1 (Account number) with its corresponding value that is Restaurant name.
I have a long list of data and I would first filter the accounts I want that are in column one. However only some of these are restaurant accounts (I'm only interested in these)
Then after filtering them, I would like the macro to run a vlookup to another sheet to search for the restaurant name that matches the content of the cell in column 1 and then paste itself as values on top of the account number.

The problem I have is these lists of data are going to vary in size, I want the macro to detect when there is no more data and then stop because I had the problem when recording it that I had to go all the way down to row 100,000 and the macro would turn really slow and it would ruin the purpose because I want to copy the data to another document to upload to SAP system.

Any ideas?

The accounts I'm interested in are the ones above: 990001348 (to help you with the initial filter) The vlookup table is on sheet 2. The column of the table I want is 3.

Thanks!!!!