Show the name of the sheet next to each search result

[cedricmeier]

Hello All,

I have the attached workbook. On the "Results" sheet, pressing one of the 4 buttons at the top left will search the other 2 sheets in the workbook for rows that contain a certain value ("Awaiting Parts", "Awaiting LCMM", "Metal Shop" or "Refinishing Shop") in column O on the other sheets. It works great how it is and displays all results correctly. The only thing that i would like to add to this is to add another column on the "Results" sheet (Column S) that would display the name of the sheet that the result was found in (e.g. Battery Shop or Face 2 Pod).

Any help would be greatly appreciated.

Thanks,
Cedric


Password to unprotect sheets or access vba code is: avso

[xladept]

Hi Cedric,

Try adding this under your copy-paste line:

Please Login or Register  to view this content.

BTW - your sample is password protected.

[cedricmeier]

Hi, thanks for your reply. The password is: avso

Where exactly do i paste this code? I'm not quite sure.

Thanks so much

[cedricmeier]

it's all good buddy. I figured it out. Thanks so much for your help.!!!!

[cedricmeier]

One more thing if you dont mind.....I would like for the "Item Name" in each search result to be a hyperlink, that would take the person to the sheet and row that the search result was found in, when they click the link. I would also like to have that row be selected on the sheet where the search result was found in.

Thanks,
Cedric

[xladept]

Hi Cedric,

You can play with this - a right-click in the Results sheet should remove its protection then a double-click on the SheetName + Row in columns S should direct you to the SheetName + Row Column O entry - you may need to double double-clickCedric.xlsm

[cedricmeier]

Thanks so much! you're awesome!!!

[xladept]

You're welcome!