I am trying to create a spreadsheet that is like a job rota. I would like to
be able to search a column (day) on one sheet and find a certain result
(job), when that result is true i would like to be able to move corresponding
information in the frst column (name) to another sheet to create a list of
all the names doing a selected job. Confused?? you bet I am.

Any help or ideas would be appreciated.

Monty
--
If I knew it all then what would there be left to live for?