VBA to find & extract data

[jiddings]

The following is a sample portion of a database output for mutiple people in mutiple departments.
I am attempting to extract employee reg pay hours Sun - Sat for Dept A only, then do the same for Dept B separately.
I'm at a loss on how to write the code to extract the regular pay hours
Any help would be appreciated.

Col A Col B Col C Col D Col E Col F Col G
<TABLE style="WIDTH: 472pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=629><COLGROUP><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><COL style="WIDTH: 48pt" span=8 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #efdecd; WIDTH: 88pt; HEIGHT: 15pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl64 height=20 width=117>EMPLOYEE:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; WIDTH: 48pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl65 width=64>1096</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; WIDTH: 48pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl66 width=64></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; WIDTH: 48pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl66 width=64></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; WIDTH: 48pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl66 width=64></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; WIDTH: 96pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl67 width=128 colSpan=2>Week Ending:</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; WIDTH: 96pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=128 colSpan=2>7/9/2011</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #efdecd; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70 height=20>DEPARTMENT:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71>Dept A</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl72></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl72></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl73 colSpan=2>Approved by:</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl75 colSpan=2></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl76 height=21></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>SUN</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>MON</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>TUE</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>WED</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>THU</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>FRI</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>SAT</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>TOTAL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 88pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl78 height=17 width=117>REG PAY</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>8.3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>6.7</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>5.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>4.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl80>24.0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 88pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl78 height=17 width=117>HOLIDAY</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>6.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl80>6.0</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl76 height=20></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81>HOL</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63 height=17></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #efdecd; HEIGHT: 15pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl64 height=20>EMPLOYEE:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl65>1179</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl66></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl66></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl66></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl67 colSpan=2>Week Ending:</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl69 colSpan=2>7/9/2011</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #efdecd; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70 height=20>DEPARTMENT:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71>Dept B</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl72></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl72></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl73 colSpan=2>Approved by:</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl75 colSpan=2></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl76 height=21></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>SUN</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>MON</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>TUE</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>WED</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>THU</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>FRI</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>SAT</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>TOTAL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 88pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl78 height=17 width=117>REG PAY</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>6.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>6.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>6.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>6.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl80>24.0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 88pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl78 height=17 width=117>HOLIDAY</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>6.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl80>6.0</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl76 height=20></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81>HOL</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63 height=17></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #efdecd; HEIGHT: 15pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl64 height=20>EMPLOYEE:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl65>1343</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl66></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl66></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl66></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #d4d0c8" class=xl67 colSpan=2>Week Ending:</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl69 colSpan=2>7/9/2011</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #efdecd; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70 height=20>DEPARTMENT:</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71>Dept A</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl71></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl72></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl72></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl73 colSpan=2>Approved by:</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl75 colSpan=2></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl76 height=21></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>SUN</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>MON</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>TUE</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl77>WED</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>THU</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>FRI</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>SAT</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl77>TOTAL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 88pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl78 height=17 width=117>REG PAY</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>6.5</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>6.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>2.3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl80>14.8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 88pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl78 height=17 width=117>HOLIDAY</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>6.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl80>6.0</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl76 height=20></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81>HOL</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl81></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #efdecd; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl82 height=20>DEPARTMENT:</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl83>Dept B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl83></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl84></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl84></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl73 colSpan=2>Approved by:</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #efdecd; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl75 colSpan=2></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 88pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl78 height=17 width=117>REG PAY</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>1.3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>2.2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl79>0.0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl80>3.5</TD></TR></TBODY></TABLE>

 

[Rick Rothstein]

I think this formula structure will do what you want...

=SUMPRODUCT(--(B2:B1000="Dept A"),I4:I1002)

where you would change the department name in the obvious location. You can replace the hard-coded department names with cell references if you wanted to take the names from a cell instead. Note that if you change the range upper limits, that both ranges must contain the same number of cells (so, the higher row number in Column I must be 2 greater than the higher row number in Column B).

 

[jiddings]

Thanks for the response.
The formula doesn't seem to work.
However, what I need to do is extract separately each employee's hours for each department and insert those hrs in a separate spreadsheet.
I'm not sure how to start with the vba

 

[Rick Rothstein]

Sorry, I misunderstood your original request (my fault, not yours). How did you want the transferred data laid out on the destination sheet? How many departments are there?

 

[jiddings]

There's only one department per worksheet and it is the full year with each employee listed in a separate column with daily hours to be added in each row.

The following is some code that I started with, but not sure where to go to extract each employee's daily hrs for the individual department.

Sub Find_EMPLOYEE()
Dim lCount As Long
Dim rFoundCell As Range
Set rFoundCell = Range("A1")
For lCount = 1 To WorksheetFunction.CountIf(Columns(1), "EMPLOYEE:")
Set rFoundCell = Columns(1).Find(What:="EMPLOYEE:", After:=rFoundCell, _
LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False)
With rFoundCell
' add additional code here
End With
Next lCount
End Sub

 

[Rick Rothstein]

There's only one department per worksheet and it is the full year with each employee listed in a separate column with daily hours to be added in each row.

So the data layout you showed us is not how it is actually laid out? Can you show us a real layout then? I'm particularly interested in know what columns belong to what employees (just tell us for two of them and I'll figure out the rest from there) and what the actual row-by-row data looks like (show maybe the first and last 10 rows for a single employee).

 

[jiddings]

Sorry to create confusion......
The sample portion of a database output for mutiple people in mutiple departments that was shown is the format that is output from the database.
Using vba, I'm attempting to paste each employee's daily hours into a yearly spreadsheet that is updated weekly. the yearly spreadsheet is formatted with the daily dates in left column and each employee's daily hours The following is a portion of the spreadsheet I'm trying to paste the weekly values into. Hopefully this will help clear the confusion I created.


<TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=640><COLGROUP><COL style="WIDTH: 48pt" span=10 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl65 height=17 width=64></TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl66 width=64>Clock #</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl84 width=64></TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl67 width=64></TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl64 width=64>3051</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl64 width=64>4269</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl64 width=64>3503</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl64 width=64>1074</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl64 width=64>3980</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl64 width=64>2751</TD></TR><TR style="HEIGHT: 83.25pt" height=111><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 83.25pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl68 height=111 width=64>Week Ending</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl68 width=64>Day of Week</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl69>TOTAL Hours</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl70 width=64>% of Total </TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl71>employee name</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl71>employee name</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl71>employee name</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl71>employee name</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl71>employee name</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl71>employee name</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl77 height=17>2-Jan</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl76 width=64>Sun</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl83>0%</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl77 height=17>3-Jan</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl76 width=64>Mon</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>67.25</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl83>23%</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>5.5</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>7.5</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>4.5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl77 height=17>4-Jan</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl76 width=64>Tue</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>48.75</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl83>17%</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>6.75</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>5.5</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>5.25</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl77 height=17>5-Jan</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl76 width=64>Wed</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>55.5</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl83>19%</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>6</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>6.75</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl85 height=17>40549</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl76 width=64>Thu</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>48.75</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl83>17%</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>6</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>4.5</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl77 height=17>7-Jan</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl76 width=64>Fri</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>52.25</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl83>18%</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>5.75</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>4</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl63>6.5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl78 height=17>8-Jan</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl79 width=64>Sat</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl82>21.25</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl80>7%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl72>0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl72>0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl72>5.5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl72>0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl72>0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl72>0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl73 height=17></TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl74>Total Week</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl73></TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>30</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>5.5</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>21.5</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>27</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl75 height=17></TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl74>Month To Date</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl73></TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl75 height=17></TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl74>Year To Date</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl73></TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD><TD style="BORDER-BOTTOM: #dcd9df; BORDER-LEFT: #dcd9df; BACKGROUND-COLOR: transparent; BORDER-TOP: #dcd9df; BORDER-RIGHT: #dcd9df" class=xl81>0</TD></TR></TBODY></TABLE>

 

[jiddings]

So the data layout you showed us is not how it is actually laid out? Can you show us a real layout then? I'm particularly interested in know what columns belong to what employees (just tell us for two of them and I'll figure out the rest from there) and what the actual row-by-row data looks like (show maybe the first and last 10 rows for a single employee).

Rick Rothstein:
Just wondering if you have any thoughts on how I can get the cell data transfered from one workbook to another with the info in my Aug 8 post.

 

[jiddings]

Can anyone offer guidance to resolve my problem??