Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fybo
 
Posts: n/a
Default Search multiple worksheets - Excel 97

Hi,

Is it possible to search for text in multiple worksheets within the one
workbook in Excel 97 (I know, my company is woefully out of date!!)?

I have 13 worksheets and want to search for a person's name or a reference
number in the entire workbook so that it will go directly to the worksheet
and cell.

Ctrl+f cannot do this and I've tried FIND, SEARCH all to no avail.

Any ideas??

Many thanks in advance.

Fybo.
  #2   Report Post  
Norman Jones
 
Posts: n/a
Default

Hi Fybo,

Look at Jan Karel Pieterse's excellent FlexFind addin which is freely
downloadable at:

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


---
Regards,
Norman



"Fybo" wrote in message
...
Hi,

Is it possible to search for text in multiple worksheets within the one
workbook in Excel 97 (I know, my company is woefully out of date!!)?

I have 13 worksheets and want to search for a person's name or a reference
number in the entire workbook so that it will go directly to the worksheet
and cell.

Ctrl+f cannot do this and I've tried FIND, SEARCH all to no avail.

Any ideas??

Many thanks in advance.

Fybo.



  #3   Report Post  
Mike
 
Posts: n/a
Default

Try right clicking on a worksheet tab and select all
Then see if Find would work.
I do not have a copy of excel97 to run this test. If not...
The find might remember the search pattern so you might be able to change
worksheets with the Find window up.

"Fybo" wrote:

Hi,

Is it possible to search for text in multiple worksheets within the one
workbook in Excel 97 (I know, my company is woefully out of date!!)?

I have 13 worksheets and want to search for a person's name or a reference
number in the entire workbook so that it will go directly to the worksheet
and cell.

Ctrl+f cannot do this and I've tried FIND, SEARCH all to no avail.

Any ideas??

Many thanks in advance.

Fybo.

  #4   Report Post  
Fybo
 
Posts: n/a
Default



"Mike" wrote:

Try right clicking on a worksheet tab and select all
Then see if Find would work.
I do not have a copy of excel97 to run this test. If not...
The find might remember the search pattern so you might be able to change
worksheets with the Find window up.

"Fybo" wrote:

Hi,

Is it possible to search for text in multiple worksheets within the one
workbook in Excel 97 (I know, my company is woefully out of date!!)?

I have 13 worksheets and want to search for a person's name or a reference
number in the entire workbook so that it will go directly to the worksheet
and cell.

Ctrl+f cannot do this and I've tried FIND, SEARCH all to no avail.

Any ideas??

Many thanks in advance.

Fybo.


Thanks! Sounds good, give a try after the weekend.
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
Unhiding multiple worksheets in Excel 2000 Juana Cafe Excel Worksheet Functions 1 September 8th 05 08:50 PM
How do I sort worksheets in excel? i.e. Order them by date Nick Excel Worksheet Functions 1 August 17th 05 06:11 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Update multiple worksheets Lizz45ie Excel Discussion (Misc queries) 0 May 31st 05 09:21 PM


All times are GMT +1. The time now is 09:49 AM.

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"