Click and search possibility?

[GoldbergJesse]

I'm looking to integrate better search/lookup functionalities to make my planning working hours more efficient. I've been searching the internet but up to now without success... Maybe you guys can help me out.


Current situation -
I've setup my planning workbook so that I have 1 main sheet with general information that is extracted from other sheets. I get all the information together through a specific concatenated key. Once I need to go in depth about a product and look up some background information I need to click on all the sheets, 5 in total and one by one look up the key in the table. I'm working on 2 screens so I have all the sheets positioned side by side. For every product I'm looking up I'm doing: copy key > click on workbook > click on filter > paste key, etc.

My wish -
What would make me very happy would be a function that when I click on a concatenated key it looks up all the info in all the sheets.

What possibilities are there? Any ideas?
If I'm not clear please let me know.

Thanks beforehand!

[mehmetcik]

This is very interesting to me.

I have a solution in mind.

However you need to specify what you would be searching for and where.

Then I would be able to write the code for you.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[newdoverman]

Take a look at this solution to a problem posted by sktneer to see if that is near to what you are looking for.

http://www.excelforum.com/showthread...t=#post4061634

[GoldbergJesse]

Hi mehmetcik,

I'm wondering what your up to! I'll have to grab some data tomorrow and get it organized. At the same time I'm thinking the layout through again. Please give me a couple of days to work this out. I'll get back to you asap.

newdover,
Thanks for thinking along! It seems that what sktneer is suggesting is a text searchbox which might be a second option. I'm hoping to find a way to go through data without having to copy/paste or type text in boxes. (utopia?)


Really appreciating the effort!

[mehmetcik]

This is what I was thinking of

Enter text in three cells highlighted yellow

click on the button and the macro will find all cells where the three bits of text exist and list the sheet and cell reference for you along with the text,

It is then easy to write a macro so that if you double click on a cell you are taken to the target sheet and cell.