Debra Dalgleish has some code (as well as manual instructions) at:
http://www.contextures.com/xlDataEntry02.html

"gfinch <" wrote:

I am trying to do something very similar. Is it possible to modify the
coding here and allow every blank cell within a column to copy the
value of the cell immediately before it. For instance, a blank in cell
B10 copies B9, blank cell B37 copies B36, etc.
Thanks for the help.
Gib

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson