Search WorkBook

edooley

New Member
Joined
Oct 6, 2002
Messages
4
I am looking for a method that I can search an entire workbook. I simply have several tabs (spreadsheets) and need to be able to search the entire workbook to find the spreadsheet that contains the information that I am looking for. Thanks in advance for any assistance.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Mark O'Brien

MrExcel MVP
Joined
Feb 15, 2002
Messages
3,530
the pretty simple manual way to do this is:

1. Right click on a tab.
2. Choose "Select All Sheets"
3. Hit CTRL+F
4. Type the info you're searching for in the dialogue box
5. It will search the whole workbook for your information.

HTH

EDIT:: I forgot to say: "Welcome to the Board"
_________________<font color = green> Mark O'Brien
This message was edited by Mark O'Brien on 2002-10-07 15:25
 

edooley

New Member
Joined
Oct 6, 2002
Messages
4
Talk about making a fella feel silly, what a great Message Board. I posted a question and 30 seconds later mutliple people provide me with a solution.

This is the best message board on the web:)

Thanks fellas,
edooley
 

Mark O'Brien

MrExcel MVP
Joined
Feb 15, 2002
Messages
3,530

ADVERTISEMENT

You're lucky to have been able to post at all. The message board is slightly screwed up right now.
 

marnie

Board Regular
Joined
Apr 26, 2002
Messages
86
I've done what Mark O'Brien recommended many times and it usually works. But if the text you are searching for exists in multiple sheets, it will only find the 1st sheet with that occurance. When you search again, it won't locate the data in the other sheets. However, I'm still working with Excel 97, so with newer versions, this may not be a problem. I'm curious to see if anyone has noticed the difference.
 

Mark O'Brien

MrExcel MVP
Joined
Feb 15, 2002
Messages
3,530

ADVERTISEMENT

It finds all instances in Excel 2000 of my test data, which is spread out over 3 sheets. It may have been an issue with Excel 97 as you've pointed out.
 

edooley

New Member
Joined
Oct 6, 2002
Messages
4
Marnie,

I am currently working with Excel 2000 and my sidekick in the office with me is using Excel 2002 - both of us are relieved that it finds items and continues to search throughout the "tabs" for mutliple occurances of the word that we are searching for, so you are exactly correct, must be a version "issue".

Hope that helps,
Eric Dooley
 

Forum statistics

Threads
1,143,707
Messages
5,720,387
Members
422,282
Latest member
psunith

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
Top