I'm a nursing student (previously an accountant), and I made an Excel file as an alternate to the very temperamental Word files that are provided to us by our school. It's helpful for a few reasons - mainly because underlined fields don't move in Excel, and when transposing data from the hospital (like in patient labs), it's easier to use Excel because I can enter data in the order provided by the hospital and use functions to rearrange them into the way our professors want them to show up.
I'm using Excel 2011 on Mac. Anyway, this brings me to three questions (some of these are forumla-based, so mods, feel free to take those questions out if you see fit):
1) I need to set Page Setups per worksheet (as page setups usually are), but it seems that the workbook unpredictably changes certain pages that need to be in landscape view back to portrait view, and changes "fit to" specifications back to "1 page wide to 1 page tall." How do I prevent this from happening? I'm having problems in particular with the Medications and Care Plan worksheets' page setup changing spontaneously. The page setup specifications I need are:
Front page: Portrait, fit to 1 page wide by 1 page tall.
Labs: Portrait, fit to 1 page wide by 1 page tall.
Medications: Landscape, print area determined by formula (see #2 below).
Assessment Data: Portrait, fit to 1 page wide by 1 page tall.
Care Plan: Landscape, fit to 1 page wide by 1 page tall.
2) I'm trying to set up a dynamic print area for the Medications page. I'm trying to use the offset function, and came up with this:
=OFFSET(Medications!$A$1,0,0,7+COUNTA(Medications!$A$8:$A$500),6)
This basically means to start at A1. The print area's number of rows will be 7 plus the number of rows with text. The print area's number of columns will be hard-entered at 6. However, when I try to do it this way, my worksheet is cut off at 4 columns. How do I fix this?
3) I notice that when columns are stretched too wide, they don't print at all. Is there a way to prevent this idiosyncrasy from happening? Other nursing students who have little experience with Excel will also be using this, and I'm just trying to get any bugs out that I can before I distribute this worksheet.
Attachment 355975
Thanks people. Have a great weekend.
EDIT: The question has also been posted here, as to not repeat anyone's work: http://www.mrexcel.com/forum/excel-q...ml#post3983200
Bookmarks