Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Views | Excel Discussion (Misc queries) | |||
Using Custom Views | New Users to Excel | |||
Custom Views | Excel Discussion (Misc queries) | |||
custom views | Excel Worksheet Functions | |||
Custom Views | Excel Discussion (Misc queries) |