ࡱ> &%  !"#$47()*+,-./01235@689:;<=>?ABRoot Entry F0 6F'1Workbook1D_VBA_PROJECT_CUR" '6F0 6FVBA;6F©6F (ɀ\p Joel Ratner Ba= ThisWorkbook=i[;8X@"1Arial1Arial1Arial1Arial1 Arial1Arial1$Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                + ) , *     `@ @   `>Sheet1ASheet2T 77"7qr1_7@=W7qr1гaOǔ~̻{=Q\a>8oցofy=A~Jh %N/xwsP&}պ8D /`[.?^@NJ{X޲?U(\Fej}Jb>|z(O{{}OSZ*Wʳ nK]a eǢ^ϋ=H}MH#G0\Ʀ[7+hN6c)h UNmّّH}Y"-sy/EAqq%%MM`lv^9?=oyI\NrMїak ǰEI_`ԮJ8AǎKI0b[ '" eǠu%)qr0^.=fgy0GSbTcvyHV!0 c԰!A̮XZb4lyr&ϭ: [a 0ci٬a+fr~1k iǒj~:^.߇&ܞro/MW ,-1h s/df/,-1?аgbIm ;)@vCmzC[Z;oCr Y9KK̅^0a+E:`~KS`-w;&B_9Hރ 0G1Y_Òkv\=&GQ6yaS?.={)4~\=P6`I 9H ,sQ6XҸo6>Blܿx(Mo%oĝ)|p(wM1 yt_t ;.3 @;(\Jtd7q޴\œ˧9~K[7UÏ4Toai)T)ci;#py({4oG ?&&Cy\7t!ae$8ep%+& ]DqY6='lUX92ϕebsYo;X(-/!p%H_!|;-^ܫ3E+eR~:^#}Mu>ec!ݐnwxFIȲ1fTB챯Œ>^(, }L@ZŽ˲Q߁;p/ xx!%,&~nsK +vb6#0>VJG:`ހ% [a y#Ñ}cIc ,m ,}4L5a)Ќ籂T2=o߫uS=q [>o ~Mb(!  7!AB~ 5܏)MȲXICM߮|o7E~ؠ0M6n %2\ӷ"l*0SC?j8t4)ŦBn ME|9giuS.__u?;m?m?m?M_+ufqO3=u///i_4)9B?wMqkxZ_1Mn1>SioSoM+trMokx Ni WWꄛj}igۏigSS19aTS6Ϧȟ ) Ϧȧ ).6ETM^N6E>TMA΅ogu|u4)Bl \r)2Buj/3DA q4}g })vF~ě-|?a}>}Cd۝pMn }hac퀟>Z|1Ml1Ml1Mn0Mn`4 eœ^Hx;ɇI!|v/{!a֓u'a |+9oDyv7{!a֑/T^Lw6ORpMg o-=8x3x-7:ԭuOiZ-ZGLGkCœkhu\uLhOf?[LXK\KL=ī!csx~ZʟZihۏў:L?[N?[Aq5S-]0Ml9SCl9{ ϖ?<ϖ' pMl)9Cl9[ YyY% TKc2ifKɗZfKr+Nil L+sLehX+ r 'ܴ?vW B*pM_l)OKC_l)tL[J[ʪ!kpM_l)LKC_l)[l:᛾RKR./6YibۏibKc;aR򛖆RnQ_l ޽\޽e`v|ʺ5v2bϡ0UF^l/lzsfaocۛޅ=;|l~|{\߱ia{;wl{Ð#L~ ئ zOWm/~' +<ÞOB8/r7߱ﴈ$kbWr7vTA:`=btw2edp4߱mְf\7LYJnkg4|Kir4߱ݫa6A>u5}{ȧ7݋{/8ؾK~=;{ Bv!:ؾC~wwl]wt8SN; ; [ NkG[!uw3]B:0M&n}or4}wЦЇQuЇz]G5WQJ~uw~=cWy{|Ӈ*+]KWCl"ŐK!Akw!:3i>N5]@pM?n5YC?n5r#&-N~wl$_w5ׇ~l4?c1a|֮ջI\Ƽ]+1}k4l&s t}frWuu] }˭"З R*\* ߯bIN*-м/]o2d9)NӗB_&6r?dCL-&1=t_ֳŐ% K!/A9c[r䟭 qkr^y7.FnJqN)s:!]܍Vkr\Gp1ŭ&_]5׉T:]ۚU䳭]gLokWUkgLo%iBo[cx%*MJVJ+0Mo+CJH]a+ L[F>! eBo7<% bnϠ{wSo(dw{߮)iMLQF>YtM|z8%d2d+M}o-=ŷ8*72edA Oq 0DXo;lFC %;d<\4)'Yf8ӹ.eRn"JnL$Z|g!1?POX< ӓONԳ!ČprNR89Bϔ|*Y1@PrD'2Myʉz~Q%'!')I􀧜/uNR4'BNe\1$d)'Q'N~@# I%'MI* zG_~r9oGɁHByʉz8$O6N33Y&fR{^I-ltwJzг꽺+7^}ON;:''!'e+<;˴SN{:'+,9)%NVp@+''̀nq҅a,q.^eRiIw8)oq.^tK''ـip"{ 4rۗ/G*\~r 89#Y8}+7v2b^Y&u?9Q,&[q"{AlGw_M|ON'qH_>翆.O2JON;tɵ=l\MeZg}f]Pɉz?dٚkޯ^}{w\ϖ8S:',9A 9}9%u?9QNfƉGSag"RKd%'ӈY!'Ӡ@: 3''*.tKN'3CNBt&KONTL&N8  RNd%'S!'S4ɉas2ՒЃgD9b$dZ$SNCɉpl&"%v"`L؇'|7WI蓐NA$ɉp6Nz>I*)}"ɨ(u?9Qq'NƉ>E*)}I u?9Q13ND N^z"-Ezqz P_"u?9Q=uNYr28r28P?N~rbB?'/c!-q HKPDU 8)XH+h\8?>8ԏ'"f N13 JwQWQ c''*m5;ڂ1>`*O裑''*n*8݆t 6裐A(ɉp6NVcHӸRGBh!u?9QNjigd#ֻV!ۤ''*^sIllz#6ҸJmG@ԏx:'Zr28-d8[ކ[''*^KN'#CNAt$GHONTz8ٌ"B*) }8[Q?\~r4ƉoAURn<{ aHG~NL 9PQ?T>rxŋA'eTֿ+Ď𸶝nͦNk +b?TSu<{&Eϵ#Xx(Jcx[X67۽݌nc{{k6l?f c#d m7c~l?fu9e>nX=FzmK=vm7c؞оflcn:84v3vyDZ݌Qql7cw͘6'ok[n8;fLcn8;fc׶1;fcSnζ=lflBm7caޙlfcۺnư kX6E^nƤ;k6 v3ƴgg{mK~d罶݌ql7cC~5}m7c@~ ~׶Y>cO͘6lf7_݌ql7c1w͘v3݌lcdDm7c%>lk͘;-l@97݌}\oa$V-L?m7c>lf,c'gzmxbFun&81mlIv3pDZ݌)ql7c[.8z]U?m7cwXv3oDZ݌kc\^n}>׶zmll_fL^틽݌[ja}W+?m7cvX6Lym3d m7c^Jk6WU^nƺlv3u^nƮ}#^fZ7 ^nƢ81g;flY7^nƐlf؎b{0 &lO-Ą brmȆvl;.xu=?[OȾv糠M?GϿ'G=^/QJhe3v9|YXoҿ >dFɇOl >8IxJm)hM3lo >@~ҟ#>>F'y?0vl>X,8B}JHBn[?v"~aƧ=Â89&>NޛEɇȂVS*b">8|ql[!؊GEG<ޓ "'fln|ض]|O mϋx"~aƻ-CW"Dܶ/qt"'f .|t (ҍyS≯,#> C>B!("'fK>u|Q|t"'fG$>:q3n%HDy?0&-y!10&ɇ{7a'>rC>8 1{pO0,c$żJy$\DO>̒G<8؈s3nIfq#qz |ĸɇ%GqTq3!K>R~uGdO>̘-8@|80˼|C h~udO>,2DA3^p%M,sS=ɇC؆⣳G>8 .r ag^!{uy?0c 7Y򱇥cQ*>@oF]ɇx%B>>udO>̘{,L+lwCoy}O0kGo3u73ny?0cc-YG}߂ޓy?0[my?0cYh u2'f|z桞ލo^z3& >y}w5PW'~aG`m==CޓueO>̘5|8i<%렋9dɇGy5X 7_u52'flW-񅫑^5{^ 5Խ&~a[|1Zq5ųՄv5[/~aeCeBz=ܶ {UÌl0cp0\ 3~j >D!w:rA_2'fL|%&[Bnmy?0k-XM|X }=˼|XX :ԭy?0cḐ|:QOcyxoS3n* >wVB_52'f,* >q |%jU˼|m t\MIC`.s$oS3It4^:3F >Z>kgZʼ|mOc< ߄M2'f| LůN}oGv3u%uǶ:PMÌk`G0o̥Bߊ2'f:K>6!7QÌ]kF!c#5ȼ|1߰C:S1uߤCuoʼ|qwX .y?0cgoc+3c+)~afG##y?0cl\/G0bs!x{=fݶOأ[yc>QoX6cyIzl!ļdcf|nsOiϏ-⛡oA3f /A)x[>8޵|l$>B>6Bo@]ɇy/W=O u2'focXvu2'f pT)%Vj|u['~ayޡ*yWQɇ+UI5?jukdO>6ZЫQW-~ac#}'SBn[}Vɼ|qWZ!M`*r^*3x%eGeGJUʼ|WXQJ| (u+eO>e|˙U]A}ˡWB-nyG{+v[!~a2_nKGYKPW&;Coq'*|3"' m,FHYزd?:@|<=b^l7eM6-?X1䨁%ES.SgWwwIp>OXл.l_.uvT @ôm4vo,?$UcS}=A]_:^F`ގݗ]%wNƠfC^5H҅OR?Es(ߕ-%{]g,:Aȟr}ӱ/SQ.Il(!/c=K1bo~Dn$b!竷6;5̡,ȱ%8A3;hcѐUm hc1,C-d$jc^6&YqIm$ޕqW.x2Qa,Eۺ m]imu:˙gbOtk#}P~ӗb$W*Dj rcڿGW2v#}β/Kvjv[iwS~>Qv,%]j2Cx:'v5W(&3eRUj5F{o2e+r9bC  Gq4(q0/Ö6ԎY\I;3[im~|nk_0>NfLJclPx,]t:na[ooh E/x681x"-C=6^WSRڗ sw%~]~ \9,,5 3b7~wܧ`Wy˟]x,V~ٔqӎq#oqq*u)2 RP:r;G;_q:uV܇z\J¹۩+RwgSw {>=\QVwis5+eXĚYqyOzzoo .\ѽf_u.ox66o~$(^.ԋu[ HnAŢoؾ7;+=bZ^}䞑[29ZطoY=ԓʲ=Xn~CmdM3 b&+Dz0.rGZ樏KܟIgȞ'/A Hޙ~֣H }>2guٮy\)߉Yy&4Ȝmco+^Y+#v%dr>;7[&ƭQ>b8ϗ,+ϗ-gԷ҉liSc%zϭskd|nxe[z!WwkoGv?1+=m aߔ;xg̩ c<}9SٗIkd+(/tz-c›ZJtd/W:~1廢 _[Pl(rhV¬奄otݟQO7jza(8}?}LBlLCiL}FAQpߨFV~{u+߷/ηb[R|E<'gz1c013#ⷷxGs}Y{yBkK?t"r 8opG?'m_ ##vfOy!8!!' ߻ =ɘ-yYLG%xV%^f&}=@7Dں;`7N6) 'a^\BR"huV3܋mMv>:=<5} ƹ-ܘ>pS~p}Ր`~kH|eKK|k*ŮG dgiπ%l+pF~qPzq=~ohӯKc3x#2<ˏwoD;8͑;;yN٣p]6Bwfydg9!Gehuzy"2sÍ4Wm]K?ەF5T/erDi_1OyL߄ɉsg?NsP<9(˦tiv=\ 皥yދ ^SlK!4̙Y0;s ! *H\!=˹Џ{cak`\ùlq\߂1z9X&:7-|wL=KA]6QacMhwұƼ푓᷇84<8>![yYMɾv.Uo3? edx'H`D_mΖs%LZNtG9V_8g8ϱɌ鬑HdxMxz-D_Kc܇Ϗ4s7SO}+a7 F X^ay=-;3yE^R^[/h;O^;@  7 Sheet3 (ɀ C  dMbP?_*+%MLexmark X6100 Series X䤗Lexmark X6100 Series8䤗 䤗"dX??UColumn A>@7 Sheet1 Module1"ThisWorkbook 9Module2ISheet1 T  !"#$%&'()*+,-./012345678:;<=>?@ABCDEFGHJKLMNOPQRSUVWXYZ[\]^_`abcefghijklmnopqrsuvwxyz{|}~C C"xME x@p'Macro recorded 6/24/2006 by Joel RatnerC 14 > `@B@Hxx?G1"  " .8 h &p "   . (8 HX "` h 4p  ,  8H$`$ 8, P4h H0 8:P  Copy_Data_to_New_File Macro( Macro recorded 6/24/2006 by Joel Ratner Keyboard Shortcut: Ctrl+Shift+CFMarriages Template$B@H B@H B@ B@"  (& ,*.0 B@$K 2(4 !6B@8 :(<ox- Combine_Data_in_All_Worksheets_JGen template]@$B@H BB@" add a sheet in first placeCombined$( copy headings8e$B@DA1$F!HB@HeA1$%FJ B@oeA2$F!HB@HoA2$%FJ B@xc work through sheetsRSO @ !L from sheet 2 to last sheet @$B@D make the sheet active00A1$FB@H#2. !NB@H' select all cells in this sheetsdoA select all lines except title [first two rows for JGen template] !T!L  %P%RB@H2 copy cells selected in the new sheet on last line VA65536$%F%#J B@ho`XճAttribute VB_Name = "Module1" Sub Copy_Data_to_New_File() D.Descriptionacro recorded 6/24/2006 by Joel Ratn erx [ProcgInvoke _FuncgC\n14E' ' MIKeyboard Shortcut: Ctrl+Shift+C Sheets("Marriages Template").Select Cells .Workbooks.Add PasteSpecial !:=xlAll, Opera None, SkipBlanks:= _A#FalsTranspose:=BActiveWindow.ZoomZ75 -lumn*utoFiD9Applic!.Cut6EnTub ŜmbinBpin_5_DsY_JGen tX`Dim J As IntegerC*COn Error Resu@Nex*Dn1iA` ' a dd a  in first 9xceECo0d' c headings 2).[Range("A1EntireR@a]DBō xtin}G# 2? R 8I' wV through%F@/JGp2 To`ie udnt@+fr@K#+2 to l[#A J$make e aUgI( ' 'urrentRegA)` s all cAv>thisc ) ' lXs except t@itle [Etw@ows fa!)X]g !Offset(2, 0).Vize(As(- G#1?!M@@Wthe new&-Aw]@65536Id(xlUpx)(2Łl}CBF#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2$+CxMExp?Gx"Attribute VB_Name = "Module2" Cv#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2C1#xME Sheet3d_VBA_PROJECTt{ dir^PROJECTwm(SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2as  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.4#0#C:\Program Files\Microsoft Office\Office10\EXCEL.EXE#Microsoft Excel 10.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.2#0#C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLL#Microsoft Office 10.0 Object Library  ?GCModule10B48ec7742Module1"I ThisWorkbook0C48ec7742YThisWorkbookBF%Module20D48ec7742ZModule20 Sheet10E48ec7742] Sheet1vH% Sheet30F48ec7742_ Sheet31`%x`0HN;U MtUG6\ЬmoO5Ct1!Gʽ I)F]@G=˼R fN/GC01+Excel+VBAWin16~Win32MacVBA6# VBAProjectstdole`OfficeuModule1b _EvaluateCopy_Data_to_New_FileASheets Cells SelectionZCopyƿ WorkbooksBAddr PasteSpecialKPaste xlPasteAllu OperationyxlNone SkipBlanksұ Transpose ActiveWindow+ZoomColumnsp9AutoFit&  Application* CutCopyModeCombine Ja WorksheetsActivate|Range  EntireRow DestinationлCount0v CurrentRegion|OffsetResize@4RowsUxlUp ThisWorkbook|Module2cSheet1Sheet3WorkbookkxY[ ]_ZZ0* pHd VBAProject4@j = r ?G J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\@10\MSO.DLL# 10.0 Ob Libra,ryKC Module1Gdu1 2 HB1pIB,B"!B+BqThisWorkbooPkG@T@sisW rkTbo 2C $%$B\F"B#$GB2OB2JB2OB2OMKBASheet_S@e@t_G2@Ic9LvK9F3GL378G3*1 ",Module1Module1ThisWorkbookThisWorkbookModule2Module2Sheet1Sheet1Sheet3Sheet3ID="{D43C38ED-D1AD-4D31-BF1F-371A2EECFBB4}" Module=Module1 Document=ThisWorkbook/&H00000000 Module=Module2 Document=Sheet1/&H00000000 Document=Sheet3/&H00000000 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="CAC8F6CEC4D2C4D2C4D2C4D2" DPB="9496A818B8E3B9E3B9E3" GC="5E5C6252E6D6B1D7B1PROJECT ,SummaryInformation(DocumentSummaryInformation8CompObjfD74E" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=22, 29, 883, 478, Z ThisWorkbook=0, 0, 0, 0, C Module2=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Sheet3=0, 0, 0, 0, C Oh+'0@H\p  Joel Ratner Joel RatnerMicrosoft Excel@t5w@^6F՜.+,0 PXd lt|  Sheet1Sheet2  Worksheets FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q