Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BBiletch
 
Posts: n/a
Default How do I search for a string across multiple worksheets in Excel?

Looking to set up a search across worksheets.
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

What version of Excel?

97 has a problem searching(find) across grouped worksheets.

No problem with the Replace feature.

Newer versions work OK.

Make sure you have "within workbook" enabled in the Find Options.

If you are running version 97, download Jan Karel Pieterse's FlexFind add-in.

http://www.jkp-ads.com/Download.htm


Gord Dibben Excel MVP

On Tue, 5 Apr 2005 14:59:06 -0700, "BBiletch"
wrote:

Looking to set up a search across worksheets.


  #3   Report Post  
BBiletch
 
Posts: n/a
Default

Thank you!!!!

"Gord Dibben" wrote:

What version of Excel?

97 has a problem searching(find) across grouped worksheets.

No problem with the Replace feature.

Newer versions work OK.

Make sure you have "within workbook" enabled in the Find Options.

If you are running version 97, download Jan Karel Pieterse's FlexFind add-in.

http://www.jkp-ads.com/Download.htm


Gord Dibben Excel MVP

On Tue, 5 Apr 2005 14:59:06 -0700, "BBiletch"
wrote:

Looking to set up a search across worksheets.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to search multiple worksheets in a workbook for information? medic2816 Excel Discussion (Misc queries) 2 March 29th 05 02:41 PM
Search for multiple words Kassie Excel Discussion (Misc queries) 0 March 25th 05 06:21 PM
Finding a record using multiple combo boxes as my search criteria sdg8481 Excel Discussion (Misc queries) 8 March 8th 05 09:36 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM
Q: search in string JIM.H. Excel Discussion (Misc queries) 5 January 5th 05 11:24 PM


All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"