Search button to search different sheet in same workbook

[l.hughes]

Hi guys,

I'm very new to excel, with a fairly loose grasp on the basics of VBA.

The problem i have is that i have two sheets within the same workbook (call them A and B) both have a lot of different fields and information.

I need a way, preferably a button, to search the selected value (xxx) in A against the masterlist in B. so for instance if the xxx value in A was 'RED CARS' i could highlight that, press the button and have a search function for incidents of 'RED CARS' in B.

As i said my knowledge is limited at best so any help at all would be appreciated.

Thanks and kind regards,

Louis

[Mumps1]

What do you want to do when you find the " incidents of 'RED CARS' in B"

[l.hughes]

Ideally highlight it, but just having it at the top of the page would be an infinite improvement

[Mumps1]

In which column in sheets A and B will 'RED CARS' be found? Can I assume that there will be multiple occurrences of 'RED CARS'? It would be easier to help and test code if we could work with your actual file. Could you post a copy of your file with a detailed explanation of what you want to achieve using a few examples?

[l.hughes]

unfortunately, do to the nature of the information i cant post it here. in sheet A the information could be anywhere in the spreadsheet, its cross referencing it with sheet B that's important in sheet B there will only ever be one occurrence and it will always be in column A

[Mumps1]

Rather than clicking on a button, the macro will automatically run when you double click the cell in sheet A that you want to find on sheet B. If you want to click on a button to run the macro, please let me know and I will modify it. Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your sheet A and click 'View Code'. Paste the macro into the empty code window that opens up. Change the sheet names to suit your needs. Close the code window to return to your sheet. Double click any cell in Sheet A.

Please Login or Register  to view this content.