Thanks for your responses....I just realized after I posted this that I can
do the same thing as fill from above only "=down"....should have thought of
this before posting....thanks again!

"deeds" wrote:

I am trying to fill a range of blanks with the data at the bottom of the
selections. Example: I want to fill the "x" cells above the 200 with 200, I
want to fill the "x" cells above the 450 with 450...etc I used the DigDb
tool but was wondering if there is another solution out there...thanks.

x
x
x
200
x
x
x
450