Custom Views

K

Khardy3352

I have two questions:
1. Currently, our patient treatment schedule is in a Word table which
requires manual calculation of treatment dates. The info is then entered
(typed) into the table, and distributed to different parties. Parts of the
table is retyped into second and third "lists" for permanent record. When
treatment is completed, their info is deleted from the Word schedule after
being retyped into another table (whew!)

I have set up an excel worksheet that includes the patient information and
calculates treatment dates. I am using Custom Views to filter information out
for different department and uses. I have a Master Document from which I
created custom views for the schedule, for the outcome record, and one other
record. When a patient's treatment is complete, I would like to hide their
info in the schedule view (all in one row) instead of deleting it as we do
now, so the practitioners are not sorting through a huge list to find pts
currently in treatment. But when I change views, to see the master document,
and return to the schedule view, the hidden row is no longer hidden. What am
I doing wrong?? Is this the best way to set up my project?

2. I set up print areas and page direction (landscape vs portrait) for each
view. Though I figured that out OK, for some reason the schedule - or
whatever view I am printing- prints in a reduced size on the bottom left of
the paper. Is this my page set up or my printer settings? I have tried for
hours to resolve this and haven't been successful...any ideas?
 
G

Gary''s Student

1. select the area to be printed
2. File > Print Area > Set Print Area
3. File > Page Setup... and then adjust both scaling and margins to suit.
 
K

Khardy3352

Thank you..one problem solved. What do you think of the "hidden row in one
view" issue? I set up a macro in the view that I want hidden rows, but still
wonder if I am developing the most efficient document for what I need. Any
thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top