I need your assistance with a small project I am working on. I know what I am going to ask you will be trivial to you considering the good knowledge many of you have of Excel functions and formulas, but please educate me.
If I have a list of names in a column... if there are three or four...
I am looking to have a front page in my workbook which has the function to search for a name with in the workbook. the Tab will be named after a person and on searching, i would like the tab(worksheet) to appear.
Can anyone help with this?