View Single Post
  #1   Report Post  
Ravvy
 
Posts: n/a
Default Series fill of "patchy" Data set or some Programming fix

In a nutshell:
To Automaticaly ascribe (copy) to all cells with no value (within a column)
that value contained in the nearest populated cell above.


In detail:
I have a "full~ish" column of non-contigious data in an excel wooksheet that
I wish to automatically fill the gap cells with the value of the nearest
non-empty cell above and continue doing this to the last row of data or the
end of the file.

Thank you in anticipation