Hi,

I have 2 work books. One is weekly schedule and other one is yearly vacation
schedule. I would like to link both books matching names and dates. Vacation
schedule is in monthly format and weekly schedule is in weekly format.

Eg: yearly vacation schdule
jan 1 Jan 2 Jan 3 and so on
ram siva
ganga

weekly schedule
jan 1 Jan 2 Jan 3
ram off 10-6 9-5
ganga off 9-5 11-7
siva 10-6 off 9-5


I need a formula in weekly schedule saying that if the date and name match
in yearly schdule says €œoff€� otherwise shift time under the same date and
name.

Thank you in advance.

Using a meaningful subject line withOUT "urgent" (All treated as urgent
here) would help. Also, it would help if you fully explained your layout and
your question.Please try again if you expect meaningful assistance.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ganga" wrote in message
...
Hi,

I have 2 work books. One is weekly schedule and other one is yearly
vacation
schedule. I would like to link both books matching names and dates.
Vacation
schedule is in monthly format and weekly schedule is in weekly format.

Eg: yearly vacation schdule
jan 1 Jan 2 Jan 3 and so on
ram siva
ganga

weekly schedule
jan 1 Jan 2 Jan 3
ram off 10-6 9-5
ganga off 9-5 11-7
siva 10-6 off 9-5


I need a formula in weekly schedule saying that if the date and name match
in yearly schdule says €œoff€� otherwise shift time under the same date and
name.

Thank you in advance.