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

Hi Michelle

No, it has more to do with the nature of the question and the ease of which
an answer can be implemented.

What you have asked for is (IMHO) not an easy thing to achieve - especially
as you have the possibility of multiple people being entered into one cell
.... so I, and probably quite a few others, didn't attempt your question,
leaving it for someone who might actually know how to do what you have asked
in an easy and efficient manner.

From my reading of the question the only way to achieve what you want is via
the use of VBA code ... however, i can't visualise an easy solution here
either ... only a brute force, check every cell, every time something
changes type solution.

Hoping someone else can give you a better answer.

Regards
JulieD

"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

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

Of course the title of the question affects the amount of replies.
Different responders have different interests.

Alan Beban

Thankyou for your help - I'm glad I won't now spend ages trying to do
something which won't really work!!!

"JulieD" wrote:

Hi Michelle

No, it has more to do with the nature of the question and the ease of which
an answer can be implemented.

What you have asked for is (IMHO) not an easy thing to achieve - especially
as you have the possibility of multiple people being entered into one cell
.... so I, and probably quite a few others, didn't attempt your question,
leaving it for someone who might actually know how to do what you have asked
in an easy and efficient manner.

From my reading of the question the only way to achieve what you want is via
the use of VBA code ... however, i can't visualise an easy solution here
either ... only a brute force, check every cell, every time something
changes type solution.

Hoping someone else can give you a better answer.

Regards
JulieD

"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

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