Chance,

You may find a whole bunch of Excel functionality available to you if you
put all the employee data in a single sheet, adding a column for name. That
may not sound appealing, but it may work well for you. Take a look at
www.smokeylake.com/excel. In "Excel truths," read "Data across multiple
tables." Strongly recommended.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Chance224" wrote in message
...
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