Insert Row When Column Amount Changes

This is a multi-part message in MIME format.

------=_NextPart_000_0080_01C55029.CC482AD0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Here is an example of what I am talking about.

     A B C D=20
      1 A B C D=20
      2 2 41100 274 584=20
      3 2 41100 274 625=20
      4 2 41100 274 333=20
      5 2 41100 274 102=20
      6 2 41100 274 957=20
      7 2 41100 274 362=20
      8 2 41100 274 651=20
      9 2 41100 274 611=20
      10 2 41100 284 965=20
      11 2 41100 284 336=20
      12 2 41100 284 251=20
      13 2 41100 284 362=20
      14 2 41100 284 859=20
      15 2 41100 284 512=20
      16 2 41100 284 669=20
      17 2 41100 284 512=20


I need to insert a new row every time the amount in Column "C"=20
changes to a different amount than the previous one.
There are approx 16,000 rows in this file or I would not be asking..lol

Thanks for any help you can offer.


--=20
Tony Johnson

--=20
Tony Johnson
------=_NextPart_000_0080_01C55029.CC482AD0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2627" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><FONT face=3DArial size=3D2>Here is an example of what I am talking =

about.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV><FONT face=3DArial =
size=3D2>
<DIV>
<TABLE style=3D"WIDTH: 240pt; BORDER-COLLAPSE: collapse" cellSpacing=3D0 =

cellPadding=3D0 width=3D320 border=3D0 x:str>
  <COLGROUP>
  <COL style=3D"WIDTH: 48pt" span=3D4 width=3D64>
  <COL style=3D"WIDTH: 48pt" width=3D64>
  <TBODY>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
    width=3D64 height=3D17></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
    width=3D64><FONT size=3D2>A</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
    width=3D64><FONT size=3D2>B</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
    width=3D64><FONT size=3D2>C</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
    width=3D64><FONT size=3D2>D</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>1</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
      size=3D2>A</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
      size=3D2>B</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
      size=3D2>C</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
      size=3D2>D</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>274</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>584</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>3</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>274</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>625</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>4</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>274</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>333</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>5</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>274</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>102</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>6</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>274</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>957</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>7</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>274</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>362</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>8</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>274</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>651</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>9</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>274</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>611</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>10</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>284</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>965</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>11</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>284</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>336</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>12</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>284</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>251</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>13</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>284</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>362</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>14</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>284</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>859</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>15</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>284</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>512</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>16</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>284</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>669</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17 x:num><FONT size=3D2>17</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>2</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>284</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
    x:num><FONT size=3D2>512</FONT></TD></TR></TBODY></TABLE></DIV>
<DIV>&nbsp;</DIV>
<DIV>I need to insert a new row every time the amount in Column "C" =
</DIV>
<DIV>changes to a different amount than the previous one.</DIV>
<DIV>There are approx 16,000 rows in this file or I would not be=20
asking..lol</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks for any help you can offer.</DIV></FONT>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><BR>-- <BR>Tony =
Johnson</FONT></DIV></DIV>
<DIV><FONT face=3DArial size=3D2><BR>-- <BR>Tony =
Johnson</FONT></DIV></BODY></HTML>

------=_NextPart_000_0080_01C55029.CC482AD0--

0
tonyj1965 (3)
5/4/2005 1:48:10 AM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
429 Views

Similar Articles

[PageSpeed] 23

This is a multi-part message in MIME format.

------=_NextPart_000_0247_01C5507F.03AA7AA0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

try this

Sub insertrowifdifferent()
For i =3D Cells(Rows.Count, "c").End(xlUp).Row To 2 Step -1
If Cells(i - 1, 3) <> Cells(i, 3) Then Rows(i).Insert
Next
End Sub

--=20
Don Guillett
SalesAid Software
donaldb@281.com
  "Ronald "Tony" Johnson" <tonyj1965@email.wintu.edu> wrote in message =
news:uUPnjtEUFHA.2172@TK2MSFTNGP10.phx.gbl...
  Here is an example of what I am talking about.

       A B C D=20
        1 A B C D=20
        2 2 41100 274 584=20
        3 2 41100 274 625=20
        4 2 41100 274 333=20
        5 2 41100 274 102=20
        6 2 41100 274 957=20
        7 2 41100 274 362=20
        8 2 41100 274 651=20
        9 2 41100 274 611=20
        10 2 41100 284 965=20
        11 2 41100 284 336=20
        12 2 41100 284 251=20
        13 2 41100 284 362=20
        14 2 41100 284 859=20
        15 2 41100 284 512=20
        16 2 41100 284 669=20
        17 2 41100 284 512=20


  I need to insert a new row every time the amount in Column "C"=20
  changes to a different amount than the previous one.
  There are approx 16,000 rows in this file or I would not be =
asking..lol

  Thanks for any help you can offer.


  --=20
  Tony Johnson

  --=20
  Tony Johnson
------=_NextPart_000_0247_01C5507F.03AA7AA0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1479" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>try this</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Sub insertrowifdifferent()<BR>For i =3D =

Cells(Rows.Count, "c").End(xlUp).Row To 2 Step -1<BR>If Cells(i - 1, 3) =
&lt;&gt;=20
Cells(i, 3) Then Rows(i).Insert<BR>Next<BR>End Sub</FONT></DIV>
<DIV><BR>-- <BR>Don Guillett<BR>SalesAid Software<BR><A=20
href=3D"mailto:donaldb@281.com">donaldb@281.com</A></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"Ronald "Tony" Johnson" &lt;<A=20
  =
href=3D"mailto:tonyj1965@email.wintu.edu">tonyj1965@email.wintu.edu</A>&g=
t;=20
  wrote in message <A=20
  =
href=3D"news:uUPnjtEUFHA.2172@TK2MSFTNGP10.phx.gbl">news:uUPnjtEUFHA.2172=
@TK2MSFTNGP10.phx.gbl</A>...</DIV>
  <DIV>
  <DIV><FONT face=3DArial size=3D2>Here is an example of what I am =
talking=20
  about.</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV><FONT face=3DArial =
size=3D2>
  <DIV>
  <TABLE style=3D"WIDTH: 240pt; BORDER-COLLAPSE: collapse" =
cellSpacing=3D0=20
  cellPadding=3D0 width=3D320 border=3D0 x:str>
    <COLGROUP>
    <COL style=3D"WIDTH: 48pt" span=3D4 width=3D64>
    <COL style=3D"WIDTH: 48pt" width=3D64>
    <TBODY>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
      width=3D64 height=3D17></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
      width=3D64><FONT size=3D2>A</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
      width=3D64><FONT size=3D2>B</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
      width=3D64><FONT size=3D2>C</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: =
transparent"=20
      width=3D64><FONT size=3D2>D</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>1</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
        size=3D2>A</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
        size=3D2>B</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
        size=3D2>C</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT=20
        size=3D2>D</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>274</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>584</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>3</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>274</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>625</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>4</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>274</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>333</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>5</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>274</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>102</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>6</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>274</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>957</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>7</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>274</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>362</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>8</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>274</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>651</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>9</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>274</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>611</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>10</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>284</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>965</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>11</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>284</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>336</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>12</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>284</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>251</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>13</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>284</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>362</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>14</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>284</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>859</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>15</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>284</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>512</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>16</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>284</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>669</FONT></TD></TR>
    <TR style=3D"HEIGHT: 12.75pt" height=3D17>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
      height=3D17 x:num><FONT size=3D2>17</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>2</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num=3D"41100.000999999997"><FONT size=3D2>41100</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>284</FONT></TD>
      <TD class=3Dxl24=20
      style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"=20
      x:num><FONT size=3D2>512</FONT></TD></TR></TBODY></TABLE></DIV>
  <DIV>&nbsp;</DIV>
  <DIV>I need to insert a new row every time the amount in Column "C" =
</DIV>
  <DIV>changes to a different amount than the previous one.</DIV>
  <DIV>There are approx 16,000 rows in this file or I would not be=20
  asking..lol</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>Thanks for any help you can offer.</DIV></FONT>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2><BR>-- <BR>Tony =
Johnson</FONT></DIV></DIV>
  <DIV><FONT face=3DArial size=3D2><BR>-- <BR>Tony=20
Johnson</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0247_01C5507F.03AA7AA0--

0
Don
5/4/2005 12:58:10 PM
Reply:

Similar Artilces:

How to change font/spacing for Outlook 2007 calendar month view?
The font and line spacing on the Outlook 2007 calendar month view makes it very difficult to read my appointments. How can I change 1) the font size, and 2) the space between lines? kgduke;146968 Wrote: > The font and line spacing on the Outlook 2007 calendar month view makes > it > very difficult to read my appointments. How can I change 1) the font > size, > and 2) the space between lines? 1. Right click on the calendar and choose Other settings to change the font. 2. You can't. -- Diane Poremsky [MVP] Diane Poremsky [MVP - Outlook] Outlo...

How to print one header over several columns of data
I want to print one title over a span of columns - what is the command? Format>Cells>Aligment>Horizontal>Center across selection? Gord Dibben MS Excel MVP On Thu, 27 May 2010 14:19:00 -0700, column title print <column title print@discussions.microsoft.com> wrote: >I want to print one title over a span of columns - what is the command? ...

How to count rows with changing data
I have an imported list on sheet2 and it is maybe 100 rows. Each day the data is imported the dates change along with the type of record associated with each date. Say this week there are 25 rows with 11/13, 20 rows with 11/14 and 25 rows with 11/15 and 30 rows with 11/16. Mixed in with this each of these dates might have a different type of record (each type has 4 options.) I need to be able to do the following: 1.) I need to count the number of occurrences for each date and not only show the total count but also show the date that is counted as the label. 2.)count the...

insert picture into excell cell
can I insert a picture into an excell cell -that will stay in that row when the spreadsheet is sorted. Any picture I insert now is attached to the spreadsheet not the specific cell. want to insert a series of thumbnails for a graphics collection. The other cells in the row will be descriptors of the picture. Thnaks Chuck ...

Changing the controls' size on the dialog
I have several controls on dialog. And the dialog is sizable. I want to change the controls size according to the dialog's size. What is the easy way to do that? http://www.codeguru.com/Cpp/W-D/dislog/resizabledialogs/article.php/c1989 "kathy" <yqin_99@yahoo.com> wrote in message news:1146251529.491759.108270@i40g2000cwc.googlegroups.com... >I have several controls on dialog. And the dialog is sizable. I want to > change the controls size according to the dialog's size. What is the > easy way to do that? > This one works pretty good. http://www.code...

How do you match one column's numbers with the 2nd column?
How do you math one column's numbers with the 2nd column? Like if you had: 1 2 2 3 3 6 4 5 6 7 ... and you wanted it sorted like so 2 2 3 3 6 6 1 4 5 7 Any idea how to do that? Thanks, Lee:confused -- lnsykalsk ----------------------------------------------------------------------- lnsykalski's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3403 View this thread: http://www.excelforum.com/showthread.php?threadid=53792 Assuming your data are in columns A and B insert a staging column before column B, with following formu...

Pivot table add one column
How can I add one column in pivot table? When I added a column of Average 100, pivot table created 3 more columns for the first 3 columns( and I don't like it) My data Book Label Price Average A Hard paper 200 100 B Soft 100 100 C Hard paper 200 100 F Plastic 50 100 K Soft 100 100 L Plastic 50 100 M Hard paper 200 100 K soft 100 100 R Soft 100 100 T Plastic 50 100 ------------------------------------------------------------------------------------------- My pivot ...

changing font size
I use Styles to define 3 or 4 different combinations of font, size, alignment etc. If I save and close the document, then come back to it some time later, I often find that font sizes have been changed. For example if I set a style called "Detail" at Garamond 12 Italic, when I reopen the document "Detail" may have been reset to Garamond 10 Italic, and this may have happened to several other styles as well. Does anyone have any idea what's happening? Publisher 2003 under Win XP Pro. Thanks in advance! Did you install the updates to Publisher 2003? -- H...

Question about automatically changing the cell�s color
How could I make the cell changes its color automatically based on the type of information I enter. Thanks, for any help almufadda@hotmail.com ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ Try Conditional Formatting (CD) For example: Suppose you want the cell's background color to change to light green if the value entered is > 10 Click on A1 Click Format > Conditional Formatting Set under Condition 1: Cell Value Is | greater than | 10 Click Format b...

Changing lowercase to uppercase in the Contacts list index
I am a vision impaired user who has often thought that it would be helpful to be able to see the alphabet that is vertically placed at the right side of the address book display. I have never been able to find a way to change this display and have concluded that I am stuck with the lower case letters. Anyone know of a way to change this setting? Thanks. It can't be changed. There is at least one tool that adds an index - not sure if it would help you though - see http://alphabet.4team.biz/ -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.n...

ListView header columns
I have a silly question, in a list view in report mode with column headers enabled I am supporting sorting the items in the list view and would like to show the silly little up and down arrows indicating ascending or decending but I don't see any property related to having them displayed. Are they a custom drawn item or am I just missing the obvious? TIA Ron Ron Hall wrote: >I have a silly question, in a list view in report mode with column headers >enabled I am supporting sorting the items in the list view and would like to >show the silly little up and down arrows indicati...

Insert "Send to associate" link in Pub 2000 web?
I am making a website in Publisher 2000 and would like to add a link for the viewer to be able to "email page to an associate". Is there a way to do this? Thank you. refer to http://www.publishermvps.com/Default.aspx?tabid=97 David Bartosik - [MSFT MVP] www.publishermvps.com www.davidbartosik.com "colleen" <anonymous@discussions.microsoft.com> wrote in message news:047401c4bdd0$225109c0$a501280a@phx.gbl... >I am making a website in Publisher 2000 and would like to > add a link for the viewer to be able to "email page to an > associate". Is t...

how to change the font color in the subject line
i like to know if i could change the font color (red, blue,...) in the subject line? if yes, please advise the steps. thanks, cwong668 you can't for sent messages, but you can change the look in your inbox by using views - specifically the automatic formatting option. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com J...

Columns
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I am working on a translation. <br> I created parallel columns as per: <br><br>I am cutting and pasting my earlier work into this format. However, my footnotes are not moving over. I tried to insert footnotes in this new version, but that option was not available in the text box. <br><br>How do I get footnotes or endnotes for the text in the text boxes? You can have either text boxes or footnotes. Footnotes cannot exist in text boxes because text boxes are not part of the text, they're graphi...

Need 2 rows to display X axis data points for a line graph
X axis is 100 data points, and all must be displayed. They do display, but are all mushed up. In Corel, you have the option to display the X axis on up to 3 rows, with interspersed tick marks. In Excel, I seem to be able only to manipulate the number of categories between tick marks and tick mark labels, but can't stagger data onto multiple rows. Any ideas or add-ins I could try? Excel 2002. Thanks, Susan This web page gives a suggestion for staggering your labels: http://peltiertech.com/Excel/Charts/Staggered.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technic...

How do I insert several documents into one folder or file
I need to combine several word documents into a file or folder so that that folder can be sent as an attachment on e-mails On Wed, 31 Oct 2007 15:55:01 -0700, Elephant1 wrote: > I need to combine several word documents into a file or folder so that that > folder can be sent as an attachment on e-mails Word Documents? You have posted this message to the wrong newsgroup. The access in this groups name refers to Microsoft Access, a database program. Please repost to the correct newsgroup for whatever version of the Word program you are using. I would suggest you include your Windows a...

Changing border thickness
I have a custom dialog box class that overrides the frame/ background drawing. I want to change the thickness of the frame border as well. The window should resize to accomodate the wider border; the client area should remain unchanged. This is what I have now: CMyDialog::OnNcCalcSize( BOOL bCalcValidRects, NCCALCSIZE_PARAMS* lpncsp ) { CDialog::OnNcCalcSize( bCalcValidRects, lpncsp ); RECT rect; GetWindowRect( &rect ); rect.left -= m_pSkin->nBorderWidth; rect.top -= m_pSkin->nBorderWidth; rect.right += m_pSkin->nBorderWidth; rect.bottom += m_pS...

cannot insert record
I have a database with two related tables and three forms. Each form shows only relevant fields for the user's needs from the two tables. In one of the forms, I cannot add a record. The option is "greyed out" in the drop down from the toolbar, as well as "greyed out" in the bar at the bottom of the only record that I currently have that is showing. I was able to add the data from another form that is working for this database. The data source is a query. The other forms tied to different queries are working fine. I would appreciate any help in locating my p...

calculated column in pivot table
Can I create a calculated column in a pivot table from two other columns. I have tried creating formulas but that does not seem to do the trick. The answer is yes. For anything less general, we'll need specifics on what you tried, and what happened. "does not seem to do the trick" does not give us much to go on. Regards, Fred "freeriderxlt" <st.jdaich@gmail.com> wrote in message news:97a60a38-262d-4a91-9474-7c26d8c44be3@a16g2000pre.googlegroups.com... > Can I create a calculated column in a pivot table from two other > columns. I have trie...

How will this work: Changing bill payer from MSN Bill Pay to my bank
My one year of MSN Bill Pay premium service, included in M03 dlx is close to expiring. So I am planning to use the service from my bank, (their bill payment service is fully integrated with Money ... they say). I'd like to know how all the payees I've setup in M03 will function if I switch Bill Pay providers?, or if anyone has any experience switching like this? For example, several payee's I've setup in M03 cannot be deleted, nor can their name be edited. I'm sure there's a reason for this, although I don't know exactly what it is, (my guess is there'...

combining data from two columns into one
Column A Column B Column C FirstName MI LastName FirstName.LastName@XXX.com Need to combine data in column A and B to make C. Can anyone help me? Thanks! ei Use a formula like: =a2&" "&b2 Regards, Fred "eintpc5146" <eintpc5146@discussions.microsoft.com> wrote in message news:B7A68BE4-41DC-46F3-B20F-737A14A5A1B4@microsoft.com... > Column A Column B Column C > > FirstName MI LastName > FirstName.LastName@XX...

Appending the rows of several tabs in xls sheets?
Is it possible to append all the rows of several tabs into one sheet? We are getting inventories in excel files organized in several tabs: 1st Tab: instructions for the users 2nd Tab: information about the country (currency, tax rate, etc) 3rd Tab: inventory of one site within the country ....to... All tabs have the same format (5 rows header, then identical Nth Tab: rows containing data about one item per row. The name of each tab 3 to N is the site name (company code). N is of course different for each country, and the number of lines in each site inventory is also variable (but they a...

Changing the domain where CRM is located
Hi, I'm installing a new domain controller on my network and I'm also changing the name of the domain. CRM 3.0 is located on its own box (SQL is stored on the same box), will the CRM 3.0 Redeployment Tool do everything I need to move CRM to the new domain? CRM will remain on the same box, I just need to connect the box to the new domain. Thanks in advanced. Regards, Cam The redeployment tool should work for this. You will need to run the export from the current system while it is still functioning. Then, follow the steps to "install" it on the servers after the...

Populating consecutive columns from a static set of cells?
I am trying to populate a master quote list and want each entry (1 row) populated by the info I enter from my quote estimate template in a separate workbook. I know how to link cells, but don't know what formula to use in the template to make each entry choose the next open row on the master list. Anybody up to the challenge? -- -Thomas Hi Thomas- If I understand your question, the first issue to clear up is that one workbook cannot 'send' data to another, i.e., your template can't send new entries to what you are calling the Master. What you need to do is work from ...

How to change default appointment length
This one has been driving me crazy for a while - I want my default appointment length to be in 15 minute increments, not 30 minutes.. There is apparently no way to do this which "sticks." While I can change the time increments in the "weekly" view to 15 minutes per section, that works. But I can't minimize the calendar to see the work day unless it is set to 30 minutes. New appointments will always then default to 30 minutes, even if I set it in the settings (by right clicking) to 15 minutes. Set up the weekly view to 15 minutes and try to use the monthly view. No luck...