Macro to fill in cell?

[Tammy]

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.

[JE McGimpsey]

See

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

In article <[email protected]>,
Tammy <[email protected]> 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.

[Tammy]

Thank you. I'm trying it right now.

"JE McGimpsey" wrote:

> See
>
> http://www.contextures.com/xlDataEntry02.html
>
> In article <[email protected]>,
> Tammy <[email protected]> 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.
>