Partial Text Lookup

[wrightyrx7]

Hi all just been watchin the new videos on youtube and seen the partial text lookup video that may come in handy at work.

Problem is its on multiple Worksheets. Let me explain....

What i do I log forms onto seperate worksheets as they come into the office.
Columns consist of:-
-Employee Number
-First Name
-Surname
-Date Recieved
-Form Type
-Date Completed
-Completed By

So i log these forms and when someone completes a form they fill in the -Date Completed & -Completed by column.

So as you might of guessed each worksheet after a while is getting longer and longer. And when an employee contacts me to see where their forms are upto i have to flick through the worksheets using CTRL+F to see if they are on that worksheet. Which is a pain in the backside.

I was wondering if anyone could help me put something on a blank worksheet to seach by employee number and it bring back all the results no matter what worksheet the information is on?


Hope i have explained it clear enough, please ask if you need any more information.

Thanks in advance

Chris

 

[wrightyrx7]

Is any of that code missing? It doesnt seem to be working..

I put it on the same way u instructed before.

Thanks again Pboltonchina

 

[wrightyrx7]

Hello, I have got into work and applied the VBA for the partial text lookup. It only seems to bring back one result from each Worksheet can anyone help?

Thanks