View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deeds Deeds is offline
external usenet poster
 
Posts: 113
Default How to fill up blanks

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