VBA - Auto fill a template in excel

[mageeg]

Hi, i have created a very simple spreadsheet to demonstrate what i am after.

Lets say i have a sheet in excel called "Data"

I then have another sheet called "Template" this is my template i want to fill in. For the sake of the explanation i have created a very simple one.

I then want to have a form like the below, in which the user enters the ID No (as it is unique) presses print and then it pulls the data from that row and fills the template above.

How would i go about doing this? I would like the user to enter the ID number, and pull the data from that row into the correct position on the template sheet.

 

[mageeg]

As that's a totally different question, it needs a new thread.
Thanks

Okay no problem. Thank you so much with your help today that worked great

 

[Fluff]

You're welcome & thanks for the feedback.

 

[mageeg]

Ok, how about

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
   Dim Fnd As Range
  
   Set Fnd = Sheets("Data").Range("A:A").Find(Me.TextBox1.Value, , , xlWhole, , , , , False)
   If Fnd Is Nothing Then
      MsgBox Me.TextBox1.Value & " not found"
      Exit Sub
   End If
   With Sheets("Template")
      .Range("B2").Value = Fnd.Offset(, 1).Value
      .Range("B4").Value = Fnd.Offset(, 2).Value
   End With
End Sub

whoops! i have found one problem (hopefully simple)

I instead tried putting as it's own sub as a macro...

If I want to call this from a different button e.g. "Print all" button that calls each sub. it says invalid use of the Me keyword, how can i get around this?

 

[Fluff]

If you are using a textbox on a userform, just leave the code in the userform module.

 

[mageeg]

whoops! i have found one problem (hopefully simple)

I instead tried putting as it's own sub as a macro...

If I want to call this from a different button e.g. "Print all" button that calls each sub. it says invalid use of the Me keyword, how can i get around this?

Nevermind - sorted this by changing "Me" with the form name