Sorting Ranges?

R

rlee1999

Board Regular
Joined
Sep 19, 2006
Messages
135
Using Excel 2013, I am creating a patient tracker for a hospital Labor and Delivery unit with 29 rooms The rooms have different designations based on their use LL1 through LL3, LR1 through LR6, 201 through 212, and 318 through 325...with the exception of room 206 which hold 2 beds 206-1 and 206-2.

The first room is LR1 (room number in A4)
Patient data from A4:U10 with several merged cells throughout the range.
There is data in every cell in ColA and when completely filled out, there will be data in every cell in the range.

The second room starts at A11

So here is what I am trying to do...When a patient moves from LL1 to LR6, I want to choose the new room number from a drop down list (I know how to make the drop list), and hit a button that sorts the entire list, keeping the patient information with it's associated room number. Under the Formulas Tab I have used the "Define Name" function to name each range. I think I am on the right track, but I could use some help as to how to proceed. Suggestions?

I have attempted to include an example of the first two ranges below...

<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
****** http-equiv=Content-Type content="text/html; charset=windows-1252">
****** name=ProgId content=Excel.Sheet>
****** name=Generator content="Microsoft Excel 15">
<link rel=File-List href="Report%20Sheet_files/filelist.xml">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
x\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style id="Report Sheet_4695_Styles">
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
.xl634695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl644695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl654695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border:.5pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
white-space:nowrap;}
.xl664695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
white-space:nowrap;}
.xl674695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:1.0pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
white-space:nowrap;}
.xl684695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:.5pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
white-space:nowrap;}
.xl694695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl704695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl714695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:right;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl724695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:left;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl734695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl744695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
white-space:nowrap;}
.xl754695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl764695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:"m\/d\;\@";
text-align:center;
vertical-align:middle;
border:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl774695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:.5pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
white-space:nowrap;}
.xl784695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl794695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl804695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:right;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl814695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:left;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl824695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:left;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl834695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:18.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:1.0pt solid windowtext;
background:#D9D9D9;
mso-pattern:black none;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl844695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl854695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl864695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl874695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl884695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl894695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl904695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl914695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl924695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl934695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl944695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl954695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl964695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl974695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl984695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl994695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl1004695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;
mso-text-control:shrinktofit;}
.xl1014695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:"h\:mm\;\@";
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl1024695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:"h\:mm\;\@";
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl1034695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:"h\:mm\;\@";
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl1044695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:right;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl1054695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl1064695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:.5pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
.xl1074695
{padding:0px;
mso-ignore:padding;
color:black;
font-size:13.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:.5pt solid windowtext;
border-bottom:.5pt solid windowtext;
border-left:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:unlocked visible;
white-space:nowrap;}
-->
</style>
</head>

<body>
<!--[if !excel]>  <![endif]-->
<!--The following information was generated by Microsoft Excel's Publish as Web
Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->

<div id="Report Sheet_4695" align=center x:publishsource="Excel">

<table border=0 cellpadding=0 cellspacing=0 width=1087 class=xl644695
style='border-collapse:collapse;table-layout:fixed;width:821pt'>
<col class=xl644695 width=73 style='mso-width-source:userset;mso-width-alt:
2669;width:55pt'>
<col class=xl644695 width=89 style='mso-width-source:userset;mso-width-alt:
3254;width:67pt'>
<col class=xl644695 width=15 style='mso-width-source:userset;mso-width-alt:
548;width:11pt'>
<col class=xl644695 width=70 style='mso-width-source:userset;mso-width-alt:
2560;width:53pt'>
<col class=xl644695 width=65 style='mso-width-source:userset;mso-width-alt:
2377;width:49pt'>
<col class=xl644695 width=29 span=2 style='mso-width-source:userset;
mso-width-alt:1060;width:22pt'>
<col class=xl644695 width=86 style='mso-width-source:userset;mso-width-alt:
3145;width:65pt'>
<col class=xl644695 width=66 style='mso-width-source:userset;mso-width-alt:
2413;width:50pt'>
<col class=xl644695 width=82 style='mso-width-source:userset;mso-width-alt:
2998;width:62pt'>
<col class=xl644695 width=43 style='mso-width-source:userset;mso-width-alt:
1572;width:32pt'>
<col class=xl644695 width=11 style='mso-width-source:userset;mso-width-alt:
402;width:8pt'>
<col class=xl644695 width=51 style='mso-width-source:userset;mso-width-alt:
1865;width:38pt'>
<col class=xl644695 width=89 style='mso-width-source:userset;mso-width-alt:
3254;width:67pt'>
<col class=xl644695 width=50 style='mso-width-source:userset;mso-width-alt:
1828;width:38pt'>
<col class=xl644695 width=10 style='mso-width-source:userset;mso-width-alt:
365;width:8pt'>
<col class=xl644695 width=50 style='mso-width-source:userset;mso-width-alt:
1828;width:38pt'>
<col class=xl644695 width=65 style='mso-width-source:userset;mso-width-alt:
2377;width:49pt'>
<col class=xl644695 width=38 span=3 style='mso-width-source:userset;
mso-width-alt:1389;width:29pt'>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl834695 width=73 style='height:22.5pt;width:55pt'><a
name="RANGE!A1:U7">LR1</a></td>
<td colspan=3 class=xl844695 width=174 style='border-left:none;width:131pt'> </td>
<td class=xl664695 width=65 style='border-left:none;width:49pt'>Age</td>
<td colspan=2 class=xl854695 width=58 style='border-right:.5pt solid black;
border-left:none;width:44pt'> </td>
<td class=xl664695 width=86 style='border-left:none;width:65pt'>Gest</td>
<td class=xl754695 width=66 style='border-left:none;width:50pt'> </td>
<td class=xl664695 width=82 style='border-left:none;width:62pt'>GP</td>
<td class=xl804695 width=43 style='border-left:none;width:32pt'> </td>
<td class=xl784695 width=11 style='width:8pt'>/</td>
<td class=xl814695 width=51 style='width:38pt'> </td>
<td class=xl664695 width=89 style='border-left:none;width:67pt'>OB</td>
<td colspan=3 class=xl884695 width=110 style='border-right:.5pt solid black;
border-left:none;width:84pt'> </td>
<td class=xl664695 width=65 style='border-left:none;width:49pt'>Peds</td>
<td colspan=3 class=xl884695 width=114 style='border-right:1.0pt solid black;
border-left:none;width:87pt'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl674695 style='height:22.5pt;border-top:none'>Allergies</td>
<td colspan=3 class=xl1004695 style='border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>BT</td>
<td class=xl714695 style='border-top:none;border-left:none'> </td>
<td class=xl724695 style='border-top:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Rubella</td>
<td class=xl694695 style='border-top:none;border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>GBS</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>HBSAG</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>ABS</td>
<td colspan=3 class=xl704695 style='border-right:1.0pt solid black;
border-left:none'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl674695 style='height:22.5pt;border-top:none'>Del Type</td>
<td colspan=3 class=xl694695 style='border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Anesth</td>
<td colspan=2 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Del Date</td>
<td class=xl764695 style='border-top:none;border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Time</td>
<td colspan=3 class=xl1014695 style='border-right:.5pt solid black;
border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Sex</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>APGAR</td>
<td class=xl704695 style='border-top:none;border-left:none'> </td>
<td class=xl694695 style='border-top:none'> </td>
<td class=xl734695 style='border-top:none'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl674695 style='height:22.5pt;border-top:none'>BW</td>
<td colspan=3 class=xl694695 style='border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>AM WT</td>
<td colspan=2 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>BR/BO</td>
<td class=xl694695 style='border-top:none;border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Score</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>D.Coombs</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Baby BT</td>
<td colspan=2 class=xl714695 style='border-left:none'> </td>
<td class=xl824695 style='border-top:none'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl674695 style='height:22.5pt;border-top:none'>HH</td>
<td class=xl714695 style='border-top:none;border-left:none'> </td>
<td class=xl634695 style='border-top:none'>/</td>
<td class=xl724695 style='border-top:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>F/F</td>
<td colspan=2 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>IV</td>
<td class=xl694695 style='border-top:none;border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Epis/LAC</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Vd/St</td>
<td class=xl704695 style='border-top:none;border-left:none'> </td>
<td class=xl634695 style='border-top:none'>/</td>
<td class=xl794695 style='border-top:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>H/S</td>
<td colspan=3 class=xl704695 style='border-right:1.0pt solid black;
border-left:none'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl674695 style='height:22.5pt;border-top:none'>NBS</td>
<td colspan=3 class=xl694695 style='border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>CCHD</td>
<td colspan=2 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Hep</td>
<td class=xl694695 style='border-top:none;border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Rdrug M/B</td>
<td class=xl714695 style='border-top:none;border-left:none'> </td>
<td class=xl634695 style='border-top:none'>/</td>
<td class=xl724695 style='border-top:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Reason</td>
<td colspan=7 class=xl704695 style='border-right:1.0pt solid black;
border-left:none'> </td>
</tr>
tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl744695 style='height:22.5pt;border-top:none'>Support</td>
<td colspan=3 class=xl974695 style='border-left:none'> </td>
<td class=xl684695 style='border-top:none;border-left:none'>Hugs</td>
<td colspan=2 class=xl954695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl774695 style='border-top:none;border-left:none'>Meds/ABX</td>
<td colspan=5 class=xl924695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl684695 style='border-top:none;border-left:none'>Concerns</td>
<td colspan=7 class=xl954695 style='border-right:1.0pt solid black;
border-left:none'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl834695 style='height:22.5pt;border-top:none'><a
name="RANGE!A8:U14">LR2</a></td>
<td colspan=3 class=xl844695 style='border-left:none'> </td>
<td class=xl664695 style='border-top:none;border-left:none'>Age</td>
<td colspan=2 class=xl854695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl664695 style='border-top:none;border-left:none'>Gest</td>
<td class=xl754695 style='border-top:none;border-left:none'> </td>
<td class=xl664695 style='border-top:none;border-left:none'>GP</td>
<td class=xl804695 style='border-top:none;border-left:none'> </td>
<td class=xl784695 style='border-top:none'>/</td>
<td class=xl814695 style='border-top:none'> </td>
<td class=xl664695 style='border-top:none;border-left:none'>OB</td>
<td colspan=3 class=xl854695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl664695 style='border-top:none;border-left:none'>Peds</td>
<td colspan=3 class=xl884695 style='border-right:1.0pt solid black;
border-left:none'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl674695 style='height:22.5pt;border-top:none'>Allergies</td>
<td colspan=3 class=xl1004695 style='border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>BT</td>
<td class=xl714695 style='border-top:none;border-left:none'> </td>
<td class=xl724695 style='border-top:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Rubella</td>
<td class=xl694695 style='border-top:none;border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>GBS</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>HBSAG</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>ABS</td>
<td colspan=3 class=xl704695 style='border-right:1.0pt solid black;
border-left:none'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl674695 style='height:22.5pt;border-top:none'>Del Type</td>
<td colspan=3 class=xl694695 style='border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Anesth</td>
<td colspan=2 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Del Date</td>
<td class=xl764695 style='border-top:none;border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Time</td>
<td colspan=3 class=xl1014695 style='border-right:.5pt solid black;
border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Sex</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>APGAR</td>
<td class=xl704695 style='border-top:none;border-left:none'> </td>
<td class=xl694695 style='border-top:none'> </td>
<td class=xl734695 style='border-top:none'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl674695 style='height:22.5pt;border-top:none'>BW</td>
<td colspan=3 class=xl694695 style='border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>AM WT</td>
<td colspan=2 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>BR/BO</td>
<td class=xl694695 style='border-top:none;border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Score</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>D.Coombs</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Baby BT</td>
<td colspan=2 class=xl714695 style='border-left:none'> </td>
<td class=xl824695 style='border-top:none'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl674695 style='height:22.5pt;border-top:none'>HH</td>
<td class=xl714695 style='border-top:none;border-left:none'> </td>
<td class=xl634695 style='border-top:none'>/</td>
<td class=xl724695 style='border-top:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>F/F</td>
<td colspan=2 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>IV</td>
<td class=xl694695 style='border-top:none;border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Epis/LAC</td>
<td colspan=3 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Vd/St</td>
<td class=xl704695 style='border-top:none;border-left:none'> </td>
<td class=xl634695 style='border-top:none'>/</td>
<td class=xl794695 style='border-top:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>H/S</td>
<td colspan=3 class=xl704695 style='border-right:1.0pt solid black;
border-left:none'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl674695 style='height:22.5pt;border-top:none'>NBS</td>
<td colspan=3 class=xl694695 style='border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>CCHD</td>
<td colspan=2 class=xl704695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Hep</td>
<td class=xl694695 style='border-top:none;border-left:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Rdrug M/B</td>
<td class=xl714695 style='border-top:none;border-left:none'> </td>
<td class=xl634695 style='border-top:none'>/</td>
<td class=xl724695 style='border-top:none'> </td>
<td class=xl654695 style='border-top:none;border-left:none'>Reason</td>
<td colspan=7 class=xl704695 style='border-right:1.0pt solid black;
border-left:none'> </td>
</tr>
<tr height=30 style='mso-height-source:userset;height:22.5pt'>
<td height=30 class=xl744695 style='height:22.5pt;border-top:none'>Support</td>
<td colspan=3 class=xl974695 style='border-left:none'> </td>
<td class=xl684695 style='border-top:none;border-left:none'>Hugs</td>
<td colspan=2 class=xl984695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl774695 style='border-top:none;border-left:none'>Meds/ABX</td>
<td colspan=5 class=xl924695 style='border-right:.5pt solid black;border-left:
none'> </td>
<td class=xl684695 style='border-top:none;border-left:none'>Concerns</td>
<td colspan=7 class=xl954695 style='border-right:1.0pt solid black;
border-left:none'> </td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=73 style='width:55pt'></td>
<td width=89 style='width:67pt'></td>
<td width=15 style='width:11pt'></td>
<td width=70 style='width:53pt'></td>
<td width=65 style='width:49pt'></td>
<td width=29 style='width:22pt'></td>
<td width=29 style='width:22pt'></td>
<td width=86 style='width:65pt'></td>
<td width=66 style='width:50pt'></td>
<td width=82 style='width:62pt'></td>
<td width=43 style='width:32pt'></td>
<td width=11 style='width:8pt'></td>
<td width=51 style='width:38pt'></td>
<td width=89 style='width:67pt'></td>
<td width=50 style='width:38pt'></td>
<td width=10 style='width:8pt'></td>
<td width=50 style='width:38pt'></td>
<td width=65 style='width:49pt'></td>
<td width=38 style='width:29pt'></td>
<td width=38 style='width:29pt'></td>
<td width=38 style='width:29pt'></td>
</tr>
<![endif]>
</table>

</div>


<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>

</html>
 
Sort by date Sort by votes
Rather that take the patient to the room why not take the room to the patient.

What I mean is, in the top left corner of the patient details have a drop down of the room list, then just select the room that patient is in.
 
Upvote 0
That is exactly what I want to do, but then I need to re-order the list by room number. The unit runs by room number, not by patient name...patients come and go, sometimes within an hour, but the room numbers are constant. The problem this sheet attempts to resolve is to replace a handwritten form that is updated every time a patient switches rooms, every time a new patient comes in and every time an existing patient is discharged.
 
Upvote 0
No problem,

I am trying to understand, what happens to this patient info when they are discharged and someone else comes in?
 
Upvote 0
I have a macro attached to a button that clears all data for that room. I have one button for each room.
Do you have any idea how to move an entire range of cells based on a sort of the cell in the upper left corner for each range?
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
917
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
3K
Attrazion
A
B
  • Question Question
Appending a Value to Each Element of a Range Array
Replies
7
Views
2K
Peter_SSs
Peter_SSs
E
  • Solved
Match sets of values
Replies
9
Views
1K
Akuini
Akuini
R
  • Question Question
Concatenate dynamic Column values with column header
Replies
2
Views
946
rockyboy
R

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top