Hi I’m hoping someone can help me I’m really new to vba and think I might be trying to do something either not possible or too hard for me to figure out on my own.
I have a workbook where there’s a main page worksheet and then each employee has a worksheet tailored to their profile with an id listed somewhere on their worksheet
On the main page I’ve added a text box where you can input part of the employee Id in case you don’t know the whole number and then a go button. What id like it to do if possible is you put either the whole or part of the employee Id in the text box then click the go button and it searches the other worksheets for the match and goes to that worksheet.
Is this something that can be achieved or not? I’m hoping one of you experienced people can point me in the right direction
Thanks
I have a workbook where there’s a main page worksheet and then each employee has a worksheet tailored to their profile with an id listed somewhere on their worksheet
On the main page I’ve added a text box where you can input part of the employee Id in case you don’t know the whole number and then a go button. What id like it to do if possible is you put either the whole or part of the employee Id in the text box then click the go button and it searches the other worksheets for the match and goes to that worksheet.
Is this something that can be achieved or not? I’m hoping one of you experienced people can point me in the right direction
Thanks