Didn't mean to offend. I just didn't get any replies last time, maybe for the
reasons you said. If you know of someone who could actually do this for me, I
would be happy to look into someone who could do future projects for me.
This site has been very useful in the past for me and has taught me much
which I am now able to use by myself. Looks like I was a bit ambitious this
time!
Michelle

"Don Guillett" wrote:

Yes, it does. NON meaningful subject lines such as this are often ignored.
Also, this is a ng for help in answering a question that may be helpful to
you in your project. It is not a place to get your projects done for
your at no fee. Many of us make our living doing projects for clients.

--
Don Guillett
SalesAid Software

"Michelle Tucker" wrote in
message ...
I have 2 excel sheets in the same workbook.
The first one has a rota on it. It is arranged in weeks, with Monday to
Sunday running along the top, and the name of the department running down
the
left hand side. At the bottom I have added a row for "holiday".
The second sheet is a holiday sheet. The names of the staff run along the
top of the sheet, with each cell underneath their name representing a days
holiday. Each cell is numbered so that we can see how many days they have,
and how many days they have left.
What I want to happen is to type the date of the holiday in the cell on
the
holiday sheet. This is the clever bit that I don't know how to do...
I want a formula in the holiday row in the rota sheet which looks for the
date at the top of the column. If it finds that date on the holiday sheet,
it
then puts the name of the person in the box. However, there may be lots of
people on holiday on the same day, so it would have to be able to list
them
(eg Michelle/Dave/Ian etc)
Possible?
--
Michelle Tucker