Hello I have the question. Im currently working to automate a process for a spreadsheet that would be populating values using vlookup in vba. Two workbooks are being used A) parking_template.xlsm and B) EFMA_template.xlsm. I want to populate a "Value" in column BC in the parking template workbook. Currently I have a vlookup formula that does this "=VLOOKUP(AJ:AJ,'[EFMS _Template.xlsm]Sheet1'!$B:$H,6,FALSE)". Im new with vba and trying to come up with my 1st macro. Any help will be appreciated. FYI, both workbooks are dynamic.