khalid79m
02-11-2009, 09:54 AM
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??
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??