Generate template based on list on another worksheet

[alyssaccasey]

I have a template on one worksheet and a list of names and amounts on another worksheet. I can't figure out a macro to update the name and award cell in the template and save the new template with the new name. Any suggestions? Thanks in advance!!!

 

[Flaiban]

Try this code :

Sub Vlookup()

Dim ws As Worksheet

Set ws = ThisWorkbook.Sheets("Template")

With ws
    .Range("P23").Formula = "=VLOOKUP(B4,List!$A:$B,2,0)"
End With


End Sub

 

[alyssaccasey]

Try this code :

Sub Vlookup()

Dim ws As Worksheet

Set ws = ThisWorkbook.Sheets("Template")

With ws
    .Range("P23").Formula = "=VLOOKUP(B4,List!$A:$B,2,0)"
End With


End Sub

Thanks for the help but it wasn't exactly what I'm looking for. I want the template to fill in with the data from the List worksheet. For example, I want the first one to have 'Sam Smith' in B4 and '$100,000' in P23 and save as File_Sam Smith and then move on to the second line. Does that make sense?