Hi,

I would like to automate a file in which I have created a Text Box and two command buttons ( SUBMIT and CLOSE). I want the user to enter the skill like six sigma,Lean etc in the text box and click on SUBMIT. After the user clicks on Submit I want to search the text entered in the Textbox in the Raw data sheet Column H and publish the findings on the first sheet below the findings. I want Staff Number,Name,Current Grade,Service Line,Business Unit,Available Date,Resource Manager,Skills of the found resource with the skill entered in the textbox from the raw data sheet. If no one found there should be a text message "No one Found".

I have attached my file for your easy understanding. I would appreciate If you could provide me any help on this. This will save my lot of time .