If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Global" search in a workbook
I have a large workbook with several sheets with similar
contents. I need to search for various text strings in the workbook and want to find all occurrences, regardless which sheet they're on. The only way I have managed is to open one sheet at a time and search for the string, which is extremely tedious.=20 Is there a way to perform as "global search" in a workbook? That would help me a lot! Thanks, G=F6rel |
#2
|
|||
|
|||
"Global" search in a workbook
"Görel" wrote in news:075601c3db48$e41c1600
: Is there a way to perform as "global search" in a workbook? That would help me a lot! You could write a VB macro that does find on each sheet. Probably someone has already written this, but it shouldn't be hard to do. -- My email address has an extra @ (spell it out) and an extra invalid. Please remove them if you are not a spammer or list broker and want to reply. |
#3
|
|||
|
|||
"Global" search in a workbook
Görel,
Look for FlexFind at : http://www.bmsltd.co.uk/MVP/Default.htm -- Regards, Auk Ales * Please reply to this newsgroup only * * I will not react on unsolicited e-mails * "Jonathan Rynd" wrote in message . .. "Görel" wrote in news:075601c3db48$e41c1600 : Is there a way to perform as "global search" in a workbook? That would help me a lot! You could write a VB macro that does find on each sheet. Probably someone has already written this, but it shouldn't be hard to do. -- My email address has an extra @ (spell it out) and an extra invalid. Please remove them if you are not a spammer or list broker and want to reply. |
Thread Tools | |
Display Modes | |
|
|