Thread
:
Please help me -urgent
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_]
external usenet poster
Posts: 1,522
Please help me -urgent
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.
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]