Search in different sheet and return in the first

[fransis]

Hi,
i would like to create a sheet like a dashboard searchin' different sheet "address book, messagges..." and returning to the first one...
The sample attached should help ... any idea?

 

[Somendra Misra]

Hi fransis,

What are you going to enter in the box? Name or anything?

Regards,

 

[fransis]

Hi fransis,

What are you going to enter in the box? Name or anything?

Regards,

Mostly the name but also a part of a message or part of a tel number...
Thanks

 

[Somendra Misra]

@fransis

Check the attached file.

Regards,

 

[Deepak]

Or you may try this....

 

[fransis]

Yepp perfect... can't understand exactly the formulas but i'll try ...
I upload a version of yours with a "justintime" search using an input box ... hope should be useful to someone else.
Thanks a lot.

 

[GN0001]

Or you may try this....

 

[GN0001]

Or you may try this....

How does this work? Please
GN0001

 

[Deepak]

Pls don't hijack other's post.
Start your new post or keep looping below link where same is asked by you.
http://chandoo.org/forum/threads/vba-code-for-combo-boxes.15789/#post-95361