I have a shared workbook that we schedule on, it has a 6 week set up from
week beginning Sat and Ending on Friday. Multiple people use this workbook.
The dates recycle, When we reach the end of the 6 weeks, we clear the
schedule and redo the dates for the next 6 weeks.
My question is this. Each week has a series of zipcodes associate with it,
that is how we choose to schedule things. If when we use the find function to
look for the zip code, it will pick up the first one it finds, what we'd like
it to do, is to go to zip code in the current week. How to I convince it to
go to the current week?
--
NealMed