<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:"Century Gothic";
        panose-1:2 11 5 2 2 2 2 2 2 4;}
@font-face
        {font-family:Georgia;
        panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
p.preheader-container, li.preheader-container, div.preheader-container
        {mso-style-name:preheader-container;
        margin:0in;
        margin-bottom:.0001pt;
        mso-line-height-alt:.75pt;
        font-size:1.0pt;
        font-family:"Times New Roman",serif;
        display:none;}
span.line
        {mso-style-name:line;}
span.grabber
        {mso-style-name:grabber;}
span.contact-detail
        {mso-style-name:contact-detail;}
span.footer-column
        {mso-style-name:footer-column;}
span.footer-mobile-hidden
        {mso-style-name:footer-mobile-hidden;}
span.EmailStyle24
        {mso-style-type:personal-reply;
        font-family:"Arial",sans-serif;
        color:#1F497D;
        font-weight:normal;
        font-style:normal;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
/* List Definitions */
@list l0
        {mso-list-id:104814521;
        mso-list-template-ids:505567312;}
@list l0:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l0:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l1
        {mso-list-id:413094846;
        mso-list-template-ids:-676411958;}
@list l1:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l1:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l1:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l1:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l1:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l1:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l1:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l1:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l1:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l2
        {mso-list-id:458184953;
        mso-list-template-ids:126364982;}
@list l2:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l2:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l2:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l2:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l2:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l2:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l2:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l2:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l2:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l3
        {mso-list-id:462164809;
        mso-list-template-ids:529843730;}
@list l3:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l3:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l3:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l3:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l3:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l3:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l3:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l3:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l3:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l4
        {mso-list-id:469398557;
        mso-list-template-ids:-1451751290;}
@list l4:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l4:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l4:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l4:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l4:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l4:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l4:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l4:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l4:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l5
        {mso-list-id:709719827;
        mso-list-template-ids:-777084614;}
@list l5:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l5:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l5:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l5:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l5:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l5:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l5:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l5:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l5:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l6
        {mso-list-id:742721850;
        mso-list-template-ids:693270760;}
@list l6:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l6:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l6:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l6:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l6:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l6:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l6:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l6:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l6:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l7
        {mso-list-id:928389211;
        mso-list-template-ids:269675952;}
@list l7:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l7:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l7:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l7:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l7:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l7:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l7:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l7:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l7:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l8
        {mso-list-id:998079456;
        mso-list-template-ids:689588156;}
@list l8:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l8:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l8:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l8:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l8:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l8:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l8:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l8:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l8:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l9
        {mso-list-id:1014385854;
        mso-list-template-ids:-1166376330;}
@list l9:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l9:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l9:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l9:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l9:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l9:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l9:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l9:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l9:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l10
        {mso-list-id:1695030676;
        mso-list-template-ids:-27862112;}
@list l10:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l10:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l10:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l10:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l10:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l10:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l10:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l10:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l10:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l11
        {mso-list-id:1743335555;
        mso-list-template-ids:-1449218128;}
@list l11:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l11:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l11:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l11:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l11:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l11:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l11:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l11:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l11:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l12
        {mso-list-id:1913350364;
        mso-list-template-ids:403441578;}
@list l12:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l12:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l12:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l12:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l12:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l12:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l12:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l12:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l12:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l13
        {mso-list-id:1973749889;
        mso-list-template-ids:-523237398;}
@list l13:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l13:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l13:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l13:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l13:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l13:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l13:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l13:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l13:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
ol
        {margin-bottom:0in;}
ul
        {margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td style="padding:0in 0in 0in 0in">
<div>
<div id="preheader">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<b><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">Greetings and welcome to this week’s issue of Tech-Talk!<br>
</span></b><span style="font-size:1.0pt">e how to connect data in different Worksheets
<o:p></o:p></span></p>
</div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="font-size:1.0pt"><img id="_x0000_i1025" src="http://r20.rs6.net/on.jsp?ca=7f634835-e19f-433c-8bb4-e705d4653902&a=1100778316270&c=980e0ed0-0713-11e6-a7b7-d4ae528ed502&ch=981cb4d0-0713-11e6-a7b7-d4ae528ed502"><o:p></o:p></span></p>
</div>
</td>
</tr>
<tr>
<td style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;background:white;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:459.0pt;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:11.25pt 3.75pt 11.25pt 3.75pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="background:#5E81CA;padding:.75pt .75pt .75pt .75pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;background:#5E81CA;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="background:white;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:white;padding:0in 0in 0in 0in">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img width="220" id="_x0000_i1026" src="http://files.constantcontact.com/ee1208b4001/34916cb2-412f-43fa-8294-1f7ecb0e9a3d.png"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:#387B37;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:19.5pt;color:white">Announcements</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:#FCFACA;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Extended through JUNE</span></b><span style="color:#333333">: If your library, school or academic institution doesn't already have an
<b>unlimited Tech-Talk license for your STUDENTS, FACULTY and PATRONS</b>, you can get one for free during this nationwide shutdown.
<a href="http://r20.rs6.net/tn.jsp?f=001oVUPqRwvmhHyJe1NramVOyFsb1nQaRLEH51PlaHXGavnPY7BhzC9Q-HjwJ1zI0nRTnAeW4qRnG95yDEy_R5ju_hKphgn2NM9lFH38JbVfoamPw6lgGdPlSP38UNEkLAmQoh6uw28W5Zc2_L_y5pLj8Pl1pE1XazXb-qsMgJXgYQ=&c=WdOyO5ZZVzWc969gGW3ub9Y0nSMCS0iv-ZGAuaJyZ457DM2U_pCAtQ==&ch=mh163X76rV0UZZ1kJoLjswWeoAyw_64dR2owLiae5w7YmfdQY0tS8A==" target="_blank">
<b><span style="color:#3661BD">Apply here</span></b></a>.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1027" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:white;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:13.5pt;color:black">UPCOMING WEBINARS</span></b><span style="color:#333333">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l8 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#241D16"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><b><span style="color:#241D16">May 20: COMMUNICATIONS: Tips for Dealing with Difficult People</span></b><span style="color:#241D16"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l8 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#241D16"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><b><span style="color:#241D16">May 27: VIDEO: In Windows 10, Create Videos With Photos App</span></b><span style="color:#241D16"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l8 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#241D16"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><b><span style="color:#241D16">June 3: DESKTOP: Organizing Thoughts & Naming Conventions</span></b><span style="color:#241D16"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l8 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#241D16"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><b><span style="color:#241D16">June 10: INTERNET: Clever Ways to Search
</span></b><span style="color:#241D16"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l8 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#241D16"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><b><span style="color:#241D16">June 17: LEADERSHIP & TEAMS: Six Questions You Must Discuss</span></b><span style="color:#241D16"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l8 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#241D16"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><b><span style="color:#241D16">June 24: WORD: More Tips and Tricks</span></b><span style="color:#241D16"><o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="50%" valign="top" style="width:50.0%;background:white;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td style="padding:7.5pt 7.5pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="background:#387B37;border-collapse:collapse;width:initial;moz-border-radius: 5px;border-radius: 5px;border-spacing: 0;min-width: initial">
<tbody>
<tr>
<td valign="top" style="padding:6.75pt 11.25pt 7.5pt 11.25pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:white"><a href="http://r20.rs6.net/tn.jsp?f=001oVUPqRwvmhHyJe1NramVOyFsb1nQaRLEH51PlaHXGavnPY7BhzC9Q8g9ZNsOXQnD-hLRqh2q0nPlLJdwYXEVpdKHqz2svQoagvRjykhecPLLiQRky2CeDG3_UxZ03Wox24Uhp51t8lx0PdzKNwaIH1Xhg0sZdDRY&c=WdOyO5ZZVzWc969gGW3ub9Y0nSMCS0iv-ZGAuaJyZ457DM2U_pCAtQ==&ch=mh163X76rV0UZZ1kJoLjswWeoAyw_64dR2owLiae5w7YmfdQY0tS8A=="><b><span style="font-family:"Arial",sans-serif;color:white;text-decoration:none">Register
 Here</span></b></a><o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<td width="50%" valign="top" style="width:50.0%;background:white;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td style="padding:7.5pt 15.0pt 7.5pt 7.5pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="background:#387B37;border-collapse:collapse;width:initial;moz-border-radius: 5px;border-radius: 5px;border-spacing: 0;min-width: initial">
<tbody>
<tr>
<td valign="top" style="padding:6.75pt 11.25pt 7.5pt 11.25pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:white"><a href="http://r20.rs6.net/tn.jsp?f=001oVUPqRwvmhHyJe1NramVOyFsb1nQaRLEH51PlaHXGavnPY7BhzC9Q19heqfCNIKa5j46kC9IwI1B9SM2zZHX0vCTzlyX7yH5pGetPn4WriNSse5lmCnQPs1QwwwcFq4thp67HLnkTmcs1he_U_1NTpRYzirRIB4QPQtrJr1V_8k=&c=WdOyO5ZZVzWc969gGW3ub9Y0nSMCS0iv-ZGAuaJyZ457DM2U_pCAtQ==&ch=mh163X76rV0UZZ1kJoLjswWeoAyw_64dR2owLiae5w7YmfdQY0tS8A=="><b><span style="font-family:"Arial",sans-serif;color:white;text-decoration:none">Watch
 the Recordings Here</span></b></a><o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1028" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333"> </span><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#333333">This Week's Topic: EXCEL / Google Sheets</span></b><span style="color:#333333">
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Tahoma",sans-serif;color:#333333"></span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#16274C">1. ARTICLE & VIDEO </span></b><span style="color:#16274C">...<b>
</b></span><span style="color:#333333">Link Data to Other Worksheets or Workbooks<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#16274C">2. COMMUNICATING </span></b><span style="color:#16274C">... End your "no" with an upbeat</span><span style="color:#333333">
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#16274C">3. LEADERSHIP</span></b><span style="color:#16274C"> ... How often do you give praise at least once every 7 days?</span><span style="color:#333333">
<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1029" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><a href="http://r20.rs6.net/tn.jsp?f=001oVUPqRwvmhHyJe1NramVOyFsb1nQaRLEH51PlaHXGavnPY7BhzC9Q004hmlYauA_KImLaPlzKb58JtHbNxGcsNrZwqqY_BoZ5qfhr1x9sUJh-GaUNX4Exb6sldvoaX37sMPcaY-CAfuywWLmEqbXWm3y29B5EbXVRjjPzWdYT12rQGagfJok3hes60j7fdVxIUa426jYH_prjDtSxTsAEg==&c=WdOyO5ZZVzWc969gGW3ub9Y0nSMCS0iv-ZGAuaJyZ457DM2U_pCAtQ==&ch=mh163X76rV0UZZ1kJoLjswWeoAyw_64dR2owLiae5w7YmfdQY0tS8A=="><span style="text-decoration:none"><img border="0" width="513" id="_x0000_i1030" src="https://files.constantcontact.com/ee1208b4001/109721c2-d4b9-4eaf-8b74-a7c1eaf369ff.png"></span></a><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.5pt;color:#111111">Photo by </span><span style="color:#333333"><a href="http://r20.rs6.net/tn.jsp?f=001oVUPqRwvmhHyJe1NramVOyFsb1nQaRLEH51PlaHXGavnPY7BhzC9Q004hmlYauA_eIvz518GgB1PWVEtOTw09nqeoAHSlIpB0jz_jelzVS0cDCTAv61tZL4NmFaoVl1IK2q2An6A1Hp8MaFuHjRarQ_JvkhRi2vi0kTYDv-V_Xlnu_4YRjigbNuzl8VhBXbkgO-iV9wYlSo7cfTKplfyM23REGhEcH-gw2RpSy2W4n9pX59_HVeP9GZmvswe7cAGfjfhcP5h-Tc=&c=WdOyO5ZZVzWc969gGW3ub9Y0nSMCS0iv-ZGAuaJyZ457DM2U_pCAtQ==&ch=mh163X76rV0UZZ1kJoLjswWeoAyw_64dR2owLiae5w7YmfdQY0tS8A==" target="_blank"><span style="font-size:10.5pt;color:#767676">Sheri
 Hooley</span></a></span><span style="font-size:10.5pt;color:#111111"> on </span><span style="color:#333333"><a href="http://r20.rs6.net/tn.jsp?f=001oVUPqRwvmhHyJe1NramVOyFsb1nQaRLEH51PlaHXGavnPY7BhzC9Q004hmlYauA_IW33WpAaGoZj7lBlRroXoXPpjlgsNRTTWRk0-dQPs4YXEImywteCWfYG6lYXEqiFRuqYOox00XwN2aZBKftjoTMf5N3o7DiWdCbcYJpgd9-vmX5z-znOV5tpKUNzQNS8hnlcWuiqZYpv3I9-k2inowAjFE69sT-jVY7gDQ_4UByqsU65xh_zj0CEMTi9lrzbwUkg0pvV4bP8iXgOHQeDx4Gxww7BTUaO&c=WdOyO5ZZVzWc969gGW3ub9Y0nSMCS0iv-ZGAuaJyZ457DM2U_pCAtQ==&ch=mh163X76rV0UZZ1kJoLjswWeoAyw_64dR2owLiae5w7YmfdQY0tS8A==" target="_blank"><span style="font-size:10.5pt;color:#767676">Unsplash</span></a>
<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:#F0F0F0;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1031" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#333333">Brought To You By
<span class="contact-detail">State Library of Oregon</span></span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:white;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1032" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="45%" valign="top" style="width:45.0%;background:white;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="166" id="_x0000_i1033" src="https://files.constantcontact.com/ee1208b4001/9975e68c-5234-456e-bd40-fe203e94bf80.png" alt="State of Oregon"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<td width="55%" valign="top" style="width:55.0%;background:white;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 7.5pt">
<div>
<div>
<p class="MsoNormal"><span style="color:#333333"><a href="http://r20.rs6.net/tn.jsp?f=001oVUPqRwvmhHyJe1NramVOyFsb1nQaRLEH51PlaHXGavnPY7BhzC9Q3TVUUCnwcD21JrkjZaiwrLe0s4obxHVC7Y_shbWe4cQ75pCAi2ACNXj5rjyaZH5ofnjecKM3khcFF28qwMaG5di7M-a-gzkaemURXRuIzpy&c=WdOyO5ZZVzWc969gGW3ub9Y0nSMCS0iv-ZGAuaJyZ457DM2U_pCAtQ==&ch=mh163X76rV0UZZ1kJoLjswWeoAyw_64dR2owLiae5w7YmfdQY0tS8A==" target="_blank"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Visit
 Tech-Talk.com Database</span></b></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="color:#333333">Username</span></b><span style="color:#333333">:
<span class="contact-detail">ORLIBTECH</span> <o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="color:#333333">Password</span></b><span style="color:#333333">:
<span class="contact-detail">ORLIBTECH</span> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="color:#333333">Questions about Tech-Talk?</span></b><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal"><span class="contact-detail"><span style="color:#333333"><a href="mailto:darci.hanning@state.or.us">darci.hanning@state.or.us</a></span></span><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1034" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:15.0pt;font-family:"Arial",sans-serif;color:#3661BD">EXCEL – Link Data to Other Worksheets or Workbooks</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><i><span style="color:#333333">Advanced</span></i><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:white;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">We recently presented a webinar on
<a href="http://r20.rs6.net/tn.jsp?f=001oVUPqRwvmhHyJe1NramVOyFsb1nQaRLEH51PlaHXGavnPY7BhzC9Q004hmlYauA_jUVqLtAf4FOi3lrvASfboFxdzxf53E8Ox32z_UlJVcyZRcKi9-LOY7y4MKsOWtLO2EbSEVx27UY-bCJ52tkj0VtzBb6iJs9wKK0DYG-XMUulxykpAqEGVImkL06JibnvDR8T7mRbitB1aHrwBJ-I4w==&c=WdOyO5ZZVzWc969gGW3ub9Y0nSMCS0iv-ZGAuaJyZ457DM2U_pCAtQ==&ch=mh163X76rV0UZZ1kJoLjswWeoAyw_64dR2owLiae5w7YmfdQY0tS8A==" target="_blank">
<span style="color:#3661BD">Advanced Techniques in Excel</span></a>. One participant asked us to explain how to link data from one Excel Sheet to another. We love it when we can take a question from a Tech-Talk reader and create a tip that may be helpful for
 others!<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:#E8E8E8;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Quick Definition: </span></b><span style="color:#333333">An Excel
<i>Workbook </i>is the entire named file. Within the Workbook are single page <i>
Worksheets</i> (or tabs at the bottom). A Workbook can contain one or more Worksheets.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Example (4 Worksheets within the one Workbook)</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:#E8E8E8;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="559" id="_x0000_i1035" src="https://files.constantcontact.com/ee1208b4001/cc34c66b-b9cb-4340-b7e8-51192a2a4f48.png" alt="worksheets"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1036" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Linking Worksheets in the
<i>Same </i>Workbook</span></b><span style="color:#333333"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Worksheets in an Excel Workbook may contain data that relates to each other. For example, you may have a budget Workbook that has 13 different Worksheets in it (one summary tab and 12 tabs representing each month
 of the year).<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Wouldn't it save time </span>
</b><span style="color:#333333">if when <b>you entered data in one of the months,</b> that
<b>total would automatically appear</b> in your summary Worksheet? It can!<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="533" id="_x0000_i1037" src="https://files.constantcontact.com/ee1208b4001/dc4bdabc-4398-43ab-9909-6cead3870fdd.png" alt="worksheet tabs"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1038" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Linking Worksheets in
<i>Different </i>Workbooks</span></b><span style="color:#333333"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Or, you may have<b> different Workbooks (separate Excel files)
</b>that have related data. In this case, you could have volunteers log their time in a "Volunteer Hours" Workbook. But for your tracking and reporting purposes, you pull those numbers into a
<i>different </i>document. <b>You can actually link the totals from one Workbook to another automatically.</b> If you change the data in one Workbook, it updates it in the other.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">CAUTION</span></b><span style="color:#333333">: One
<i>important </i>detail to remember. <b>You will want to save both files in a location that is static, preferably the same folder.
</b>You can't move either file around, email a file to someone, etc. -- as it will break the connection (formula) and you may lose data. So this solution is possible if care is used.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif;color:#3661BD">Let's Set Up the Example Situation</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">In the technical directions below,
<b>it will be helpful to understand the situation</b> we're using so that you won't get lost as you move back and forth between "source" and "destination" spreadsheets ... and navigating within one or more workbooks.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">We've created an imaginary library</span></b><span style="color:#333333"> that holds five "income generating" events every year (e.g.
<i>Silent Auction, Book Fair</i>, etc.). This organization wants to have one spreadsheet that shows, year over year, how their
<i>net </i>income compares after they've taken out all the expenses. They want to automate the process so that entries in the individual event sheets, update the master one.</span><span style="color:#BF3F2F">
</span><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">So let's take a look at <i>how
</i>to link data in Excel files.</span></b><span style="color:#333333"> <o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1039" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">How to Link Data from One Worksheet to Another in the
<i>SAME </i>Workbook</span></b><span style="color:#333333"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">For clarification, we will refer to a<b> "Source Worksheet" – which is where the
<i>original</i> data resides</b>. And a <b>"Destination Worksheet"</b> which contains the<b> link (formula) where data is updated automatically.</b>
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">In our first example </span></b><span style="color:#333333">we have one Workbook for "<i>Event Income Tracking"</i> that has several Worksheets in it ... one for each individual event. We want the net income
 of each event (from the source Worksheets) to be automatically updated in the summary tab (the destination Worksheet).
<b>There are two methods you could use.</b> <o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:4.45pt;word-wrap: break-word">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1040" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="265" id="_x0000_i1041" src="https://files.constantcontact.com/ee1208b4001/f147dfa6-15b6-43e3-9383-99075b9ceba1.png" alt="copy and paste"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1042" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1043" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Option #1: Copy and Paste</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l10 level1 lfo2">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">With the master Workbook open (the one with all the spreadsheets), go to the
<i>source </i>Worksheet (the input data), <i>highlight </i>the cell with the data that you want in the other spreadsheet,
<i>right-click </i>and choose <i>Copy</i>.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l10 level1 lfo2">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">Next, go to the destination Worksheet tab (summary sheet), put your cursor in the cell where you want the data to show and automatically update when the underlying source numbers change ... but
<b>don't paste yet!</b> <o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l10 level1 lfo2">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">From the <i>Home </i>tab,
<b>click on the drop-down arrow</b> in the <i>Paste </i>button, and from <i>Other Paste Options</i> choose
<i>Paste Link</i>.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l10 level1 lfo2">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><b><span style="color:#333333">Or, right-click</span></b><span style="color:#333333"> in the cell on the destination worksheet and choose
<i>Paste Link</i> from the <i>Paste Options.</i> <o:p></o:p></span></p>
</div>
</div>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p>
<p></p>
<div align="center"></div>
</p>
</tr>
</tbody>
</table>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="316" id="_x0000_i1044" src="https://files.constantcontact.com/ee1208b4001/633b0c3e-00cc-4a64-9019-4c4026d98aa7.png" alt="paste link"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l12 level1 lfo3">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">Hit the Esc key to move out of that cell.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Now anytime the content</span></b><span style="color:#333333"> from the cell in the
<i>source </i>Worksheet changes, it will update in the destination tab.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1045" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Option #2: Enter the Formula</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Alternately, you can <b>enter the formula manually</b>.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l3 level1 lfo4">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">In this case, go to the
<i>destination </i>Worksheet and put your cursor in the cell where you want the data to pull in from your
</span><i><span style="color:black">source </span></i><span style="color:#333333">tab.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l3 level1 lfo4">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">Enter an equal sign (=)<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="440" id="_x0000_i1046" src="https://files.constantcontact.com/ee1208b4001/e72b7146-30e0-4d3a-bb03-a4104d0a020c.png" alt="enter ="><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l11 level1 lfo5">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#222222"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#222222">Then go to the <i>source</i> tab, click on the cell that contains the data and press the
<i>Enter </i>key on your keyboard.  <o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="412" id="_x0000_i1047" src="https://files.constantcontact.com/ee1208b4001/7a2033d4-5677-4d15-808c-62aadbcfe120.png"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l4 level1 lfo6">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">The data will now appear in the destination Worksheet.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Using either method,</span></b><span style="color:#333333"> now anytime the content from the cell in the source Worksheet changes, it will update in the destination tab.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1048" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Link Data from One Workbook to a
<i>DIFFERENT </i>Workbook</span></b><span style="color:#333333"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Creating the links between the spreadsheets in
<i>different workbooks </i>is the <b>same </b>as above: <b>Option # 2-- <i>Enter the Formula.
</i></b>(<b>NOTE</b>:<b> </b><i>Option #1: Copy and Paste</i> does <b><i>not </i>
</b>work between different workbooks.)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">However, there are important considerations to keep in mind...</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l0 level1 lfo7">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">When <i>creating </i>the connection,
<b>BOTH Workbooks need to be OPEN.</b> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l9 level1 lfo8">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><b><span style="color:#333333">And if you <i>change
</i>data in the source Worksheet</span></b><span style="color:#333333"> <b>when both Excel files are open</b>, it will automatically update. But if both Workbooks are
<i>not</i> open, the next time you open the destination file that contains the references,<b> you will get a message that looks like this: Click
<i>Update </i>to refresh the file.</b> <o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="487" id="_x0000_i1049" src="https://files.constantcontact.com/ee1208b4001/04d743d6-3b5e-4e72-8b8b-f57c4b362bb4.png" alt="update file"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l7 level1 lfo9">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><b><span style="color:#333333">Again, if you move one or both</span></b><span style="color:#333333"> of the Excel Workbooks (the destination or source files)
<b>to a new location</b>, the file path is essentially broken. Keeping both documents in the same folder is recommended.<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1050" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Linking in Google Sheets</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">You can link Workbooks and Sheets in Google Sheets, however, the process is a bit different.
</span><span style="color:black">You have to put in formulas, you can't copy and paste.</span><span style="color:#333333">
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">In this example, we have a source sheet (called
<i>Silent Auction</i>) and destination sheet (referred to as <i>Event Income Summary)</i>.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:4.45pt;word-wrap: break-word">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1051" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="266" id="_x0000_i1052" src="https://files.constantcontact.com/ee1208b4001/3b189c9a-bc46-413b-b1c0-449c776bbd7e.png" alt="Event Income Summary"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1053" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1054" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">To </span></b><b><span style="color:black">connect
</span></b><b><span style="color:#333333">one Worksheet to another in the <i>same
</i>Workbook:</span></b><span style="color:#333333"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l6 level1 lfo10">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">In the source Worksheet note the cell reference that you want to carry over to the destination sheet. In this example it is
<b>D20</b>.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l6 level1 lfo10">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">Go to the destination sheet and click in the cell where you want the linked data to appear.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l6 level1 lfo10">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><b><span style="color:#333333">Type</span></b><span style="color:#333333">: 1) an equal sign (=); 2) followed by the sheet name; 3) then an exclamation point (!) that serves as a separator; 4) followed by the cell name.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">In our source file</span></b><span style="color:#333333"> it looks like this:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333">=SilentAuction!D20<o:p></o:p></span></p>
</div>
</div>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p>
<p></p>
<div align="center"></div>
</p>
</tr>
</tbody>
</table>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="520" id="_x0000_i1055" src="https://files.constantcontact.com/ee1208b4001/d2a32998-60c4-4c74-9458-2e689e0d3099.png" alt="event summary"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l1 level1 lfo11">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">Then press <i>Enter</i>.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#3661BD">IMPORTANT</span></b><b><span style="color:#333333">:</span></b><span style="color:#333333"> If your "tab
<i>name" </i>has a <i>space </i>in it, then you need to enclose that name in <i>single
</i>quotes. So if the tab name in this example was <i>Silent Auction</i>, the formula would be:<o:p></o:p></span></p>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333">='Silent Auction'!D20<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1056" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Link Data in
<i>Different </i>Google Sheets Files</span></b><span style="color:#333333"> <o:p>
</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">It's a bit more complicated to link from one Sheet in Google to a different Sheet file. It involves
<b>adding the file name (the URL path) of the sheet</b> in the formula (because the document is online).<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l2 level1 lfo12">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">Open the source Google Sheet and copy the file name -- the whole URL at the top of the window.<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="507" id="_x0000_i1057" src="https://files.constantcontact.com/ee1208b4001/b2bb87f4-16c5-4ccc-bcd8-47893059cb96.png" alt="source file name"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l13 level1 lfo13">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">With that copied, go to your destination Google Sheet.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l13 level1 lfo13">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">The formula will be a series of information that point to the cell reference staring with: 1) =importrange; 2) followed by the file name of the Sheet; 3) the tab (sheet name); and 4) the cell reference.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l13 level1 lfo13">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">For our example, it would look like this (note where parenthesis and comma are added):<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="color:#333333">=importrange("<a href="https://docs.google.com/spreadsheets/...">https://docs.google.com/spreadsheets/...</a>" , "SilentAuction!D20")</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="560" id="_x0000_i1058" src="https://files.constantcontact.com/ee1208b4001/cbc544b1-6d35-4411-9f4e-4e296f456579.png" alt="file path"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:4.45pt;word-wrap: break-word">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1059" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="246" id="_x0000_i1060" src="https://files.constantcontact.com/ee1208b4001/b2ad0e3a-c166-49f7-a12b-5f0cac48cd53.png" alt="allow access"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1061" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1062" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l5 level1 lfo14">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">    
</span></span></span><![endif]><span style="color:#333333">Then click <i>Enter</i>.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">You may get an error message </span>
</b><span style="color:#333333">that prompts you to allow access to the file. Click the
<i>Allow access</i> blue button.<o:p></o:p></span></p>
</div>
</div>
</div>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1063" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:#F0F0F0;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" style="border-collapse:collapse;margin-right:4.45pt;word-wrap: break-word">
<tbody>
<tr style="height:.75pt">
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="180" id="_x0000_i1064" src="https://files.constantcontact.com/ee1208b4001/41d9a61c-7e5a-4de3-b0a4-4021dd05cea3.png"><o:p></o:p></p>
</div>
</td>
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1065" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
<tr style="height:.75pt">
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1066" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1067" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#333333">Communications: Talking & Writing</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><i><span style="color:#333333">Say "No" with a positive spin</span></i><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">You invite someone to join you in an early morning Pilates exercise. Your friend says, "<i>Thank you for thinking of me, but I will decline."</i>
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Notice how you feel. Rather rejected, right?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Now imagine </span></b><span style="color:#333333">she had said the same thing but in a different order.
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><i><span style="color:#333333">"I will decline, but thank you for thinking of me."</span></i><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Don't you feel better hearing the same message but with the positive part at the end?
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Whatever is said last, is the message that lingers. So if you want people to feel better when you're delivering a "no" ... or an unpleasant message ... consider ending on an upbeat.
<o:p></o:p></span></p>
</div>
</div>
</div>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1068" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:white;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" style="border-collapse:collapse;margin-right:4.45pt;word-wrap: break-word">
<tbody>
<tr style="height:.75pt">
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="180" id="_x0000_i1069" src="https://files.constantcontact.com/ee1208b4001/da1c6ee9-ba35-4af5-9c80-8e1b5781189e.png"><o:p></o:p></p>
</div>
</td>
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1070" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
<tr style="height:.75pt">
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1071" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1072" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#333333">Leadership
</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><i><span style="color:#333333">How often do you give praise?</span></i><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">The <i>Story of MO </i>(<i>Win </i>
as the Executive, <i>Riptorn </i>as the Manager / Supervisor, and <i>Val </i>as the Employee) has been published in over 50 different industry journals.
</span><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">The topic .... '<i>organizational indifference.'</i>
</span><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">This is what happens when the <i>"VALs"
</i>in the company aren't being listened to, aren't being included in the big picture, aren't being respected for adding
<i>value</i> to the organization.</span><span style="color:#333333"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:black">True Story.</span></b><span style="color:black"> A month after the articles were published we received a phone call from an engineer in California. He said...</span><span style="color:#333333">
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><i><span style="color:black">“I saw your topic in 'Facilities Engineer' and I really liked it. </span></i><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><i><span style="color:black">But there was one thing you said that
</span></i><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><i><span style="color:black">would have to be changed for our environment. </span></i><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><i><span style="color:black">You had a quiz, with the question,
</span></i><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><i><span style="color:black">'</span></i><span style="color:black">How often do you receive praise at least once every seven days?'</span><span style="color:#333333">
<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><i><span style="color:black">In our world, you would want to ask,
</span></i><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><i><span style="color:black">'How often do you receive praise at least once every seven years.'</span></i><span style="color:#333333"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">When we tell the story in person, people tend to laugh. Why? Because it is so sad, yet so real.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">You don't have to be a <i>Riptorn</i> (manager) to give praise.</span></b><span style="color:#333333">
<i>You </i>can take the lead in your group to make sure that everyone's ideas are heard and considered.
<i>You</i> can put forth the praise (privately and in a team setting).<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Ask Yourself</span></b><b><span style="font-family:"Courier New";color:#333333">…</span></b><span style="color:#333333">
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">1.</span><span style="font-size:7.0pt;font-family:"Georgia",serif;color:#333333">
</span><span style="color:#333333">How well do I observe when others do great things, have creative ideas?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">2.</span><span style="font-size:7.0pt;font-family:"Georgia",serif;color:#333333">
</span><span style="color:#333333">How often do I give praise? What can I do to make this a habit?<o:p></o:p></span></p>
</div>
</div>
</div>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr style="height:.75pt">
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 8.25pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1073" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="50%" valign="top" style="width:50.0%;background:#3661BD;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><a href="http://r20.rs6.net/tn.jsp?f=001oVUPqRwvmhHyJe1NramVOyFsb1nQaRLEH51PlaHXGavnPY7BhzC9Q8D6Y-gK_Luu2mLqfaSJ8gg_MDqlaruu1yNsTcn63K1h7_eFTT0kYBCnYiSYHv-OGbJj2GeKKCfmJCOYjx3aeAH3U4iNpHHkSoR6Vfh7clM6&c=WdOyO5ZZVzWc969gGW3ub9Y0nSMCS0iv-ZGAuaJyZ457DM2U_pCAtQ==&ch=mh163X76rV0UZZ1kJoLjswWeoAyw_64dR2owLiae5w7YmfdQY0tS8A=="><span style="text-decoration:none"><img border="0" width="272" id="_x0000_i1074" src="http://files.constantcontact.com/ee1208b4001/b13a7a6a-7445-4d8e-b741-4b475385ef5b.png"></span></a><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<td width="50%" valign="top" style="width:50.0%;background:#3661BD;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><a href="http://r20.rs6.net/tn.jsp?f=001oVUPqRwvmhHyJe1NramVOyFsb1nQaRLEH51PlaHXGavnPY7BhzC9QzvbUDAAWvBK7EHDlEHfsHta8dT8gNltLccIbi7HfaxuCNBAkytr81Ohds5iQUF_EbwRXwrcObGKDXOfrb7VEQAZcHgHFrpmCIlBUTrKsEDkvRi1g3kPA70=&c=WdOyO5ZZVzWc969gGW3ub9Y0nSMCS0iv-ZGAuaJyZ457DM2U_pCAtQ==&ch=mh163X76rV0UZZ1kJoLjswWeoAyw_64dR2owLiae5w7YmfdQY0tS8A=="><span style="text-decoration:none"><img border="0" width="271" id="_x0000_i1075" src="http://files.constantcontact.com/ee1208b4001/8751eb23-fa9b-43ba-9f5f-7e80a465c6c5.png" alt="Ask a question"></span></a><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#333333">Copyright 1996-2020 Shared Results International. Published weekly. Distribution is limited by license. For information on how to include additional recipients,
 contact <a href="mailto:support@tech-talk.com">support@tech-talk.com</a> 941-355-2092.</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D">The Tech-Talk e-newsletter for Oregon library staff is distributed weekly via the Libs-OR and TechTalk mailing lists.<b>
</b>Know someone who might be interested in receiving a copy but they’re not on TechTalk or Libs-OR mailing lists? Have them contact
<a href="mailto:darci.hanning@state.or.us">darci.hanning@state.or.us</a> or visit
<a href="http://listsmart.osl.state.or.us/mailman/listinfo/techtalk">http://listsmart.osl.state.or.us/mailman/listinfo/techtalk</a> to subscribe to just the Tech-Talk newsletter!<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D">Tech-Talk is a paid subscription service for staff of Oregon libraries and is supported in whole by the Institute of
 Museum and Library Services (IMLS) through the Library Services and Technology Act (LSTA), administered by the State Library of Oregon.</span></b><span style="font-family:"Arial",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div></div>
<div></div>
<div></div>
<div></div>
<div></div>
<div></div>
<div></div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:3.0pt"><b><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif;color:black">Darci Hanning, MLIS</span></b><b><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif;color:black"><o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F4E79">Public Library Consultant / CE Coordinator<br>
</span></b><span style="font-family:"Calibri",sans-serif;color:#2E74B5"><a href="https://libguides.osl.state.or.us/coronavirus"><span style="color:#0563C1">https://libguides.osl.state.or.us/coronavirus</span></a><br>
</span><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F4E79"><br>
</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F4E79"><a href="mailto:darci.hanning@state.or.us"><b><span style="color:#2E74B5">darci.hanning@state.or.us</span></b></a><b> | 503-378-2527|
</b><a href="https://www.oregon.gov/library"><b><span style="color:#0563C1">www.oregon.gov/library</span></b></a></span><span style="font-family:"Calibri",sans-serif;color:#2E74B5"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F4E79">Follow us:
<a href="https://fb.me/StateLibraryOR"><span style="color:#0563C1">Facebook</span></a> |
</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F4E79"><a href="https://twitter.com/StateLibraryOR"><b><span style="color:#0563C1">Twitter</span></b></a><b> |
<a href="https://www.instagram.com/statelibraryor/"><span style="color:#0563C1">Instagram</span></a> |
</b><a href="https://pinterest.com/statelibraryor/"><b><span style="color:#0563C1">Pinterest</span></b></a><b><o:p></o:p></b></span></p>
<p class="MsoNormal" style="margin-bottom:3.0pt;line-height:115%"><span style="font-size:11.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#1F4E79"><br>
<img border="0" width="342" height="43" id="Picture_x0020_1" src="cid:image001.png@01D62DF3.CA13DAD0" alt="cid:image005.png@01D31C27.4B9FEA30"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div></div>
<div></div>
</body>
</html>