Find a value a post data to another worksheet

[Les Stout]

Good Day,

I am using Vlook up's to look up a number or a name which is typed into
a cell, this then brings the values to the right of the given number in
the table, into cells on another work sheet. There are 11 columns of
data.
I would like to do this which VBA, is it possible ?


Les Stout

 

[Ron de Bruin]

Here is a simple example

Sub test()
mynum = Application.InputBox("Enter a number", Type:=1)
Sheets("Sheet2").Range("B1").Value = _
Application.WorksheetFunction.VLookup(mynum, Range("data"), 2)
End Sub