Hi
I hope you can help me. My wife is a nurse and has the hospital ward duty
shift on an excel spreadsheet. Across the top is the date and down the left
hand side are the nurses names. The chart itself has a D for day, N for
night, X for day off and AL for annual leave. From this they want to print a
list of individual days. So they could highlight a date and then printout
(on one page) a list of who is on nights, days, etc. They have excel 2002
(office XP).
I hope you can help. Thanks in advance for any help you can give me.
Eric
Paul Cundle - 28 Sep 2003 17:07 GMT
The obvious answer is to hide the columns for the days you don't want before
printing, or set the print area to cover only the columns you want.
I suspect, however, you'd like something more than this - such as having
each day for the next couple of weeks printed off on individual pages
without having to manually hide and unhide columns? I suggest you try asking
in news:microsoft.public.excel.programming since the experts there should be
able to come up with something pretty decent. It is a very busy group,
though, so if you provide a little more information (and ideally a sample
spreadsheet) then I (and others here) would be happy to help here.
Paul C,

Signature
> Hi
>
[quoted text clipped - 8 lines]
>
> Eric