Finding data in grouped sheets

S

SusieV

When using the 'find' option whilst workbook pages are grouped together I am getting data from the last page first, then the last but one etc. Can anyone tell me whether it is possible to change this so that it finds the data in the first possible page, ie it looks at page 3 before page 4 etc?
What I am trying to do is set up a spreadsheet which finds the first 'vacancy' in a childrens nursery. As I have set it up at the moment it is finding the last vacancy first!
All help greatly received! Thanks in advance.
Susie Vaughan
 
D

Dave Peterson

This may not quite fit, but you may find it very useful for any finds/replaces.

Try Jan Karel Pieterse's FlexFind:
http://www.bmsltd.ie/MVP/

It pops up a nice dialog listing all the found cells. Then you can select the
cell you want.
 
Top