how do i do a search in a spreadsheet thas has multiple worksheet
P Peo Sjoblom Mar 23, 2006 #2 Group the sheets before you start the search (click first sheet tab, hold down shift and click last), don't forget to ungroup when you are done -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon
Group the sheets before you start the search (click first sheet tab, hold down shift and click last), don't forget to ungroup when you are done -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon
D Dave Peterson Mar 23, 2006 #3 Just to add to Peo's suggestion. If you're using xl2k or above, Peo's suggestion will work fine. If you're using xl2002+, there's an option to search through the workbook on the Edit|Find dialog. And if you're using xl97, you may want to try Jan Karel Pieterse's FlexFind: http://www.oaltd.co.uk/MVP/ (It'll actually work in all these versions.)
Just to add to Peo's suggestion. If you're using xl2k or above, Peo's suggestion will work fine. If you're using xl2002+, there's an option to search through the workbook on the Edit|Find dialog. And if you're using xl97, you may want to try Jan Karel Pieterse's FlexFind: http://www.oaltd.co.uk/MVP/ (It'll actually work in all these versions.)