Good afternoon all.
Complicated to explain issue, but here goes...
I am trying to automatically update cells in a master spreadsheet with data input manually in other sheets. Sounds easy.
The Users input date and period information of all proposed leave, on a spreadsheet relevant to them.
See examples of input sheets below for three separate Users.
Joe Bloggs
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 47px"><COL style="WIDTH: 47px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Name:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>JOE BLOGGS</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Leave Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>April 2009 - March 2010</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Annual Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">33</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Carried over from Last Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">0</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Total Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">33</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD> </TD><TD> </TD><TD> </TD><TD style="FONT-WEIGHT: bold"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Annual</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Study Leave</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Professional</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Official</TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">3/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">15/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">9</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>G7</TD><TD>=G5+G6</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
Jerry Bloggs
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 47px"><COL style="WIDTH: 47px"><COL style="WIDTH: 40px"><COL style="WIDTH: 43px"><COL style="WIDTH: 43px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Name:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>JERRY BLOGGS</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Leave Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>July 2009 - June 2010</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Annual Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">33</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Carried over from Last Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">1</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Total Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">34</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD> </TD><TD> </TD><TD> </TD><TD style="FONT-WEIGHT: bold"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Annual</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Study Leave</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Professional</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Official</TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">22/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">24/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">3</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">3/8/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">6/8/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">4</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">8/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">8/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">13/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">17/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">5</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>G7</TD><TD>=G5+G6</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
Jack Bloggs
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 47px"><COL style="WIDTH: 47px"><COL style="WIDTH: 40px"><COL style="WIDTH: 43px"><COL style="WIDTH: 43px"><COL style="WIDTH: 40px"><COL style="WIDTH: 43px"><COL style="WIDTH: 43px"><COL style="WIDTH: 40px"><COL style="WIDTH: 43px"><COL style="WIDTH: 43px"><COL style="WIDTH: 40px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Name:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>JACK BLOGGS</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Leave Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>April 2009 - March 2010</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Annual Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">33</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Carried over from Last Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">0</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Total Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">33</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD> </TD><TD> </TD><TD> </TD><TD style="FONT-WEIGHT: bold"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Annual</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Study Leave</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Professional</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Official</TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">10/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">10/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">15/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">15/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">20/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">21/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">2</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>G7</TD><TD>=G5+G6</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
As can be seen the data can be in any number of categories (annual, study ...etc) and repeated over a number of rows.
The objective is to take the date information in rows 12 downwards for each sheet and by macro or otherwise transfer that information into a date timelime on the master sheet. Therefore the end result should look something like the following for Joe, Jerry and Jack Bloggs:
Summary
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 107px"><COL style="WIDTH: 63px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD><TD>P</TD><TD>Q</TD><TD>R</TD><TD>S</TD><TD>T</TD><TD>U</TD><TD>V</TD><TD>W</TD><TD>X</TD><TD>Y</TD><TD>Z</TD><TD>AA</TD><TD>AB</TD><TD>AC</TD><TD>AD</TD><TD>AE</TD><TD>AF</TD><TD>AG</TD><TD>AH</TD><TD>AI</TD><TD>AJ</TD><TD>AK</TD><TD>AL</TD><TD>AM</TD><TD>AN</TD></TR><TR style="HEIGHT: 54px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; TEXT-ALIGN: center">Days remaining</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">01/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">02/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">03/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">04/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">05/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">06/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">07/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">08/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">09/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">10/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">11/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">12/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">13/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">14/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">15/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">16/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">17/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">18/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">19/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">20/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">21/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">22/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">23/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">24/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">25/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">26/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">27/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">28/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">29/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">30/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">31/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">01/08/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">02/08/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">03/08/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">04/08/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">05/08/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">06/08/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">07/08/2009</TD></TR><TR style="HEIGHT: 16px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt">Joe Bloggs</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">xx</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 16px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 8pt">Jerry Bloggs</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">yy</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 16px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 8pt">Jack Bloggs</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">zz</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR></TBODY></TABLE>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
A form button on each sheet with an underlying macro would be ideal. Not sure nor confident about how to go about looking up the input sheet dates and person's name and then looking up the master sheet for the corresponding name and date period and then plonking the date timeline in!
All and any help would be appreciated.
I think this query and resultant answer will get someone into the Hall of Fame!
Regards.
Gary
Complicated to explain issue, but here goes...
I am trying to automatically update cells in a master spreadsheet with data input manually in other sheets. Sounds easy.
The Users input date and period information of all proposed leave, on a spreadsheet relevant to them.
See examples of input sheets below for three separate Users.
Joe Bloggs
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 47px"><COL style="WIDTH: 47px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Name:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>JOE BLOGGS</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Leave Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>April 2009 - March 2010</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Annual Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">33</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Carried over from Last Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">0</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Total Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">33</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD> </TD><TD> </TD><TD> </TD><TD style="FONT-WEIGHT: bold"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Annual</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Study Leave</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Professional</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Official</TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">3/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">15/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">9</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>G7</TD><TD>=G5+G6</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
Jerry Bloggs
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 47px"><COL style="WIDTH: 47px"><COL style="WIDTH: 40px"><COL style="WIDTH: 43px"><COL style="WIDTH: 43px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"><COL style="WIDTH: 40px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Name:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>JERRY BLOGGS</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Leave Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>July 2009 - June 2010</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Annual Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">33</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Carried over from Last Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">1</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Total Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">34</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD> </TD><TD> </TD><TD> </TD><TD style="FONT-WEIGHT: bold"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Annual</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Study Leave</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Professional</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Official</TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">22/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">24/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">3</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">3/8/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">6/8/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">4</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">8/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">8/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">13/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">17/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">5</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>G7</TD><TD>=G5+G6</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
Jack Bloggs
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 47px"><COL style="WIDTH: 47px"><COL style="WIDTH: 40px"><COL style="WIDTH: 43px"><COL style="WIDTH: 43px"><COL style="WIDTH: 40px"><COL style="WIDTH: 43px"><COL style="WIDTH: 43px"><COL style="WIDTH: 40px"><COL style="WIDTH: 43px"><COL style="WIDTH: 43px"><COL style="WIDTH: 40px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Name:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>JACK BLOGGS</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left" colSpan=2>Leave Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=4>April 2009 - March 2010</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Annual Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">33</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Carried over from Last Year:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">0</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; COLOR: #ff0000"><= input number</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00">Total Leave Entitlement:</TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">33</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-WEIGHT: bold; BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD style="BACKGROUND-COLOR: #ffff00"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD> </TD><TD> </TD><TD> </TD><TD style="FONT-WEIGHT: bold"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Annual</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Study Leave</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Professional</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center" colSpan=3>Official</TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">From</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">To</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 7pt; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">Days</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">10/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">10/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">15/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">15/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">1</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">20/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">21/7/09</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: right">2</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>G7</TD><TD>=G5+G6</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
As can be seen the data can be in any number of categories (annual, study ...etc) and repeated over a number of rows.
The objective is to take the date information in rows 12 downwards for each sheet and by macro or otherwise transfer that information into a date timelime on the master sheet. Therefore the end result should look something like the following for Joe, Jerry and Jack Bloggs:
Summary
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 107px"><COL style="WIDTH: 63px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"><COL style="WIDTH: 17px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD><TD>P</TD><TD>Q</TD><TD>R</TD><TD>S</TD><TD>T</TD><TD>U</TD><TD>V</TD><TD>W</TD><TD>X</TD><TD>Y</TD><TD>Z</TD><TD>AA</TD><TD>AB</TD><TD>AC</TD><TD>AD</TD><TD>AE</TD><TD>AF</TD><TD>AG</TD><TD>AH</TD><TD>AI</TD><TD>AJ</TD><TD>AK</TD><TD>AL</TD><TD>AM</TD><TD>AN</TD></TR><TR style="HEIGHT: 54px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; TEXT-ALIGN: center">Days remaining</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">01/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">02/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">03/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">04/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">05/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">06/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">07/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">08/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">09/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">10/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">11/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">12/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">13/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">14/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">15/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">16/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">17/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">18/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">19/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">20/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">21/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">22/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">23/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">24/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">25/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">26/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">27/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">28/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">29/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">30/07/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">31/07/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">01/08/2009</TD><TD style="FONT-SIZE: 6pt; BACKGROUND-COLOR: #ff0000; TEXT-ALIGN: right">02/08/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">03/08/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">04/08/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">05/08/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">06/08/2009</TD><TD style="FONT-SIZE: 6pt; TEXT-ALIGN: right">07/08/2009</TD></TR><TR style="HEIGHT: 16px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt">Joe Bloggs</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">xx</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 16px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 8pt">Jerry Bloggs</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">yy</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 16px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 8pt">Jack Bloggs</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">zz</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #000000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ff0000"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD></TR></TBODY></TABLE>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
A form button on each sheet with an underlying macro would be ideal. Not sure nor confident about how to go about looking up the input sheet dates and person's name and then looking up the master sheet for the corresponding name and date period and then plonking the date timeline in!
All and any help would be appreciated.
I think this query and resultant answer will get someone into the Hall of Fame!
Regards.
Gary
