Discount Price List

[The Animal]

Hi.
I have a weekly price list that is generated in XL (as below)
<TABLE style="WIDTH: 314pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=420><COLGROUP><COL style="WIDTH: 16pt; mso-width-source: userset; mso-width-alt: 987" width=22><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 5046" width=110><COL style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 1536" width=34><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1609" width=35><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2523" width=55><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 2084" width=46><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2852" width=62><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2560" width=56><TBODY><TR style="HEIGHT: 12.9pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 16pt; HEIGHT: 12.9pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69 height=17 width=22></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 83pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl85 width=110>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl85 width=34>B</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 26pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl85 width=35>C</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 41pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl85 width=55>D</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 34pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl85 width=46>E</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 47pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: green 1pt solid" class=xl86 width=62>F</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: green; BACKGROUND-COLOR: transparent; WIDTH: 42pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl84 width=56>G</TD></TR><TR style="HEIGHT: 12.9pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.9pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70 height=17>1</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: green 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: green 1pt solid; BORDER-RIGHT: gray 0.5pt solid" class=xl74>Artichoke - Globe</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: green 1pt solid; BORDER-RIGHT: gray 0.5pt solid" class=xl75>box</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: green 1pt solid; BORDER-RIGHT: gray 0.5pt solid" class=xl75>24</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: green 1pt solid; BORDER-RIGHT: gray 0.5pt solid" class=xl76>$30.20</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: green 1pt solid; BORDER-RIGHT: gray 0.5pt solid" class=xl77>each</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: green 1pt solid; BORDER-RIGHT: green 1pt solid" class=xl78>$1.55</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: green; BACKGROUND-COLOR: transparent; WIDTH: 42pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl84 width=56>0.95</TD></TR><TR style="HEIGHT: 12.9pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.9pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70 height=17>2</TD><TD style="BORDER-BOTTOM: green 1pt solid; BORDER-LEFT: green 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl83>Jerusalem</TD><TD style="BORDER-BOTTOM: green 1pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl79>box</TD><TD style="BORDER-BOTTOM: green 1pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl79>5kg</TD><TD style="BORDER-BOTTOM: green 1pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl80>$44.60</TD><TD style="BORDER-BOTTOM: green 1pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl81>each</TD><TD style="BORDER-BOTTOM: green 1pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: gray; BORDER-RIGHT: green 1pt solid" class=xl82>$11.20</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: green; BACKGROUND-COLOR: transparent; WIDTH: 42pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl87 width=56> </TD></TR><TR style="HEIGHT: 12.9pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.9pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70 height=17>3</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: green 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: green; BORDER-RIGHT: gray 0.5pt solid" class=xl74>Asparagus- Green</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: green; BORDER-RIGHT: gray 0.5pt solid" class=xl75>box</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: green; BORDER-RIGHT: gray 0.5pt solid" class=xl75>30</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: green; BORDER-RIGHT: gray 0.5pt solid" class=xl76>$44.70</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: green; BORDER-RIGHT: gray 0.5pt solid" class=xl77>each</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: transparent; BORDER-TOP: green; BORDER-RIGHT: green 1pt solid" class=xl78>$1.65</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: green; BACKGROUND-COLOR: transparent; WIDTH: 42pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl87 width=56> </TD></TR></TBODY></TABLE>

I want to create a additional 5% discount list but do not want to change each cell manually. I have another workbook that I show the discounted price in a seperate column where I just change the % discount by changing a cell off the printed form with a formula like =A1*$N$1 then all I have to do is change cell to .95 (5% discount) etc. In this case I just want to create the original price list each week and just change the discount cell (G1 in this case) but I do not want to create an additional column plus a rounding up of $0.20 for boxes and $0.05 for each. So line 1 column D changes to $28.80 and $1.50 for boxes.
Any help much appreciated.
Stephen