Spreadsheet printing

[Eric Draven]

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

 

[Graham Haughs]

Hi Eric,
You could do this using a vlookup and match function. If you
list your nurses names down a column starting at A4 for example you could
enter this formula in B4 then copy it down the column oposite the nurses
names.
VLOOKUP(A4,$D$1:$J$7,MATCH($A$1,$D$1:$J$1,0),FALSE)
where D1:J7 is the array of names and dates you have already. I have just 7
columns and 7 rows.
A1 is the date you have chosen ( you could create a drop down list for
this), and
D1:J1 is the range of dates but note this contains one blank cell at D1.
Hope this helps.

Kind regards,
Graham Haughs
Turrif, Scotland

 

[M. lane]

If excel 2002 is like excel 2000, then just highlight the cells to print,
choose print area from the file menu and click set print area. Now print.
But if excel 2002 is different, maybe someone else has the answer.