Suggestion

[Moily]

Hi there,

I am developing a weekly calendar with workdays of the week across the top
and each hour listed vertically. I have a list of 50 items that need to go
into the calendar in the correct day/time. The list of items has columns
titled Weekday, Name, Code, Start, End, Option and HalfYear. I want to have
two calendars: one for each halfyear (values 1 or 2 in relevent column). I
want Name, Code, Start, End to be in one cell that would correlate to correct
day/time. ie. if Ann 123456 is working Monday starting at 11 and ending at 2
I'd like to have "Ann 123456 11-2" in the Monday 11am calendar cell). There
would be no more than 3 on any given day/time. I assume I'd need to have a
vlookup in there to look up the Weekday and bring back the Name, Code and
dates but I'm not sure how to mix two up. Also I'd assume i'd have to
concatenate the four columns to paste into the one cell in the calendar but
i'm not sure how.

Any suggestions?

Thanks,
Ann

 

[Pete_UK]

Hi Ann,

send me an email to:

pashurst <at> auditel.net

(change the obvious).

I can send you a calendar where you can list actions on one sheet (in
any order) and on the other sheet you can select month and year from
two pull-downs and then see the actions displayed in a claendar
format. It's not exactly in the format you describe, but it could be
modified to give you what you want.

I'm off to a family wedding tomorrow, so if I don't receive your email
before about 10:00am my time (BST), then I won't be able to get back
to you until Monday.

Pete