G Guest May 13, 2005 #1 I am trying to find data that could be on any of the sheets in my excel work book is there a way of searchind all sheets at once?
I am trying to find data that could be on any of the sheets in my excel work book is there a way of searchind all sheets at once?
G Guest May 13, 2005 #2 From the Edit menu, choose "Find", click the "Options>>" button to extend the dialogbox to show the advanced options. In the "Within" dropdown list, choose "Workbook". Regards, Edwin Tam (e-mail address removed) http://www.vonixx.com
From the Edit menu, choose "Find", click the "Options>>" button to extend the dialogbox to show the advanced options. In the "Within" dropdown list, choose "Workbook". Regards, Edwin Tam (e-mail address removed) http://www.vonixx.com
D Dave Peterson May 13, 2005 #3 Edwin's response will work with xl2002+. But Jan Karel Pieterse's addin FlexFind: http://www.oaltd.co.uk/MVP/ will work in all versions of xl.
Edwin's response will work with xl2002+. But Jan Karel Pieterse's addin FlexFind: http://www.oaltd.co.uk/MVP/ will work in all versions of xl.