Hi BJ,

Firstly thanks for trying to help.

In answer to your questions there are multiple sheets, but all the
information is transfered to a sheet called "master rota" which is where i
would like to source the information from. It is then transfered to a daily
sheet eg "sunday listing".

The layout of the "master sheet" is each man in the team (Col A) then the
job is in (col B). Eg joe bloggs Rest Day

The sheet i am transfering to ("sunday listing") has job headings for each
column so lets say column a is rest day. The idea is to put anyone who has
"rest day" next to their name in the "master listing" worksheet into a new
list in the "sunday listing" sheet.

I hope thats what you're after, I think I may be trying to over complicate
things.

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


"bj" wrote:

do you have two or three sheets?
you first want to know if a "Job" appears on one sheet
you then go to a second sheet and extract names
the list of names associated with the job then gets listed on what sheet?
on sheet 2 how are jobs and people formated?
job with a list of people next to it or under it, or
two columns (rows) one with jobs and one with people (each can occur many
times)

"Monty" wrote:

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?