workbook search

  1. R

    Search entire workbook with around 10-15 sheets and update a cell listing which sheets contains that information.

    I have a workbook that contains around 10-15 sheets which all contain employee information based on what they are currently alligned to. I was wondering if anyone knows of a formula or a way to search through all of the sheets and if the employee details are found on any of the sheets, that the...
  2. S

    Search multiple items in all worksheets.

    Hello, I have the following code and I am having trouble figuring out how to change it so I can put in a list of different names in the search and have the results show up on different rows. Example: This code will add a new worksheet with the following info Workbook, Worksheet, Cell and Text...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top