replace vlookup with vba

hi I was able to complete a workbook thanks largely to thisd forum. what im trying to do now is to replace all vlookups with a vba to increase processer speed and further automate its design. I do not know how to use vba at all and would like the simplest terms possible.

sheet a_____________________sheet b
__A________B_________________A______B
adam______?________________david___17
david______?________________adam___18
gary_______?________________gary____20

using vlookup question marks are their equivalent ages. I want those values to come from sheet b to sheet a automatically with vba. the sheet values are much longer and the range is vastly more extensive but I think this will be a good starting point. please answer me simply as possible so that I may follow

Originally Posted by SSJAMES18

hi I was able to complete a workbook thanks largely to thisd forum. what im trying to do now is to replace all vlookups with a vba to increase processer speed and further automate its design.

Hi,

You are mistaken if you believe writing VBA code to replicate standard functionality will be quicker than using standard Excel functions like VLOOKUP(). It won't, it will be slower and if looping over large ranges is involved very slow.

If your VLOOKUP is working then the smartest way to proceed to automate the system is to get VBA to write the VLOOKUP in the sheet and copy it as necessary. e.g.

Please Login or Register  to view this content.