View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Macro to fill in cell?

See

http://www.contextures.com/xlDataEntry02.html

In article ,
Tammy wrote:

Hi - can anybody tell me how to write a macro for excel to fill in blanks, in
a column with the data from the cell above, til it gets to a non-blank cell,
then repeats?

I want it to copy the cell directly above, then fill in the blanks below
with that number, and continue til it gets to another number, then repeats
with next number etc.