And if you're using xl2002 or higher, there's an option under Edit|Find to
search the entire workbook (if those names are in a cell).

If you're using xl2k or below, you can use a nice Find utility from Jan Karel
Pieterse.

It's called FlexFind and you can find it he
http://www.oaltd.co.uk/MVP/

(In fact, it'll work with any version of excel.)

Chance224 wrote:

I have a workbook to track employee's time. There is a sheet for every
employee and then a recap sheet that totals the hours & etc. How can I make
a macro to search for a certin name and then activate that sheet. We have
alot employee's and its a pain to search for the person and enter in the data.

Thanks,
Chance

--

Dave Peterson