View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan Thompson[_2_] Dan Thompson[_2_] is offline
external usenet poster
 
Posts: 3
Default Automating Fill series Function Multiple times ?

I hope someone can help me out.
I have a column of data with blank gaps for example somthing like the
following

15
46
55

32
21


48
59

I can manual select the value before the gaps/blank cells to the value after
the gaps so that they are highlighted and just do a Fill series function and
excel atuomaticly will interpolate values for the gaps. However I have a
rather large data set with lots of gaps and it is not very practical to do
this manualy for each gap in the column of data. I am have been trying to get
excell to automaticly do this for all the gaps, however have not found a
method to do this.

Any suggestions or help ?

Dan.