Select the column with the numbers. Then Edit/Goto, click the Special button
and select Blanks. The active cell will be one of the blanks. In that cell
type an equal sign (to start a formula), and point to the cell above. ExampleL
if cell B2 is active, the formula will end up as =B1. Then press CTRL+ENTER,
which will enter that formula in all of the blank cells. Then select all of
the filled cells in that column, Edit/Copy them, then Edit/Paste Special, and
select the Values option.


On Wed, 8 Jun 2005 20:10:20 -0500, "Charles P. \(Pat\) Upshaw"
wrote:

I have a table containing periodic rates at monthly intervals from 1970.
Not all months have numbers, so I want those months rates to equal the
previous month's rate. How do I "fill in" these blanks?

Example:

01/1985 - 25.00
02/1985
03/1985
04/1985 - 29.25
05/1985
06/1985
07/1985 - 19.00
08/1985
09/1985

I have to do this over and over again, so I need a routine. I need for
02/1985 to equal 25.00; and 05/1985 to equal 29.25, etc.

Thanks,
Pat Upshaw