Solved: Forms in VBA

[khalid79m]

Firstly all I have no exprience with building forms etc, so please bear with me if I ask stupid questions.

I have a sheet labelled CallData, This has a several column headers which are Staff_Number, Name, (Ps the column headers are the names of the named range , eg Staff_Number = a2:a10000 and Name = B2:b10000

Now on the other sheet CallForm I need to have a drop down box linked to the staff numbers which is easy peasy but what i need it to do is once this is populated , place a filter on calldata sheet for that staff member and also bring back his or her name,

can anyone help a beginner??

[Bob Phillips]

=VLOOKUP(A2,CallData!A2:B10000,2,FALSE)

[khalid79m]

thanks worked