Using 'find' when workbook pages are grouped together?

[Guest]

I have found that when I have pages of a workbook grouped and I use the 'find' function, it finds data on the last page first, then the second but last etc. Can anyone tell me please whether I can change this so that I can find data on the first available page? I am trying to set up a spreadsheet to identify vacancies for a childrens nursery & obviously want it to find the first page with a vacany shown not the last!

Yours in anticipation
Susie V

 

[Andy B]

Hi

I would suggest using FlexFind:
http://www.jkp-ads.com/Download.htm#Flexfind
It is a very powerful search facility that is an Excel add-in.

--
Andy.

I have found that when I have pages of a workbook grouped and I use the

'find' function, it finds data on the last page first, then the second but
last etc. Can anyone tell me please whether I can change this so that I can
find data on the first available page? I am trying to set up a spreadsheet
to identify vacancies for a childrens nursery & obviously want it to find
the first page with a vacany shown not the last!