How do I auto fill long col. filling blanks with last filled cell

On a large worksheet, is there a way to fill the blanks in a column with the
last filled cell without using the autofill handle? My worksheet is over 2000
rows and I am hoping to find some way to mass fill the blanks in Excel. Here
is a small example of what I am talking about. Thanks for any tips.
S1475 201686
506456
S1888 38254
15623
56731
S9564 46321
156323

M,
This ought to work...
http://j-walk.com/ss/excel/usertips/tip040.htm
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"MBBeginner" <[email protected]> wrote in message news:[email protected]...
On a large worksheet, is there a way to fill the blanks in a column with the
last filled cell without using the autofill handle? My worksheet is over 2000
rows and I am hoping to find some way to mass fill the blanks in Excel. Here
is a small example of what I am talking about. Thanks for any tips.
S1475 201686
506456
S1888 38254
15623
56731
S9564 46321
156323

Debra Dalgleish has some techniques at:
http://www.contextures.com/xlDataEntry02.html

Try the manual method. I've found it's quicker than the code!

MBBeginner wrote:
>
> On a large worksheet, is there a way to fill the blanks in a column with the
> last filled cell without using the autofill handle? My worksheet is over 2000
> rows and I am hoping to find some way to mass fill the blanks in Excel. Here
> is a small example of what I am talking about. Thanks for any tips.
> S1475 201686
> 506456
> S1888 38254
> 15623
> 56731
> S9564 46321
> 156323

--

Dave Peterson

It worked. I cannot tell you how thrilled I am. Thank you so much.

"Dave Peterson" wrote:

> Debra Dalgleish has some techniques at:
> http://www.contextures.com/xlDataEntry02.html
>
> Try the manual method. I've found it's quicker than the code!
>
> MBBeginner wrote:
> >
> > On a large worksheet, is there a way to fill the blanks in a column with the
> > last filled cell without using the autofill handle? My worksheet is over 2000
> > rows and I am hoping to find some way to mass fill the blanks in Excel. Here
> > is a small example of what I am talking about. Thanks for any tips.
> > S1475 201686
> > 506456
> > S1888 38254
> > 15623
> > 56731
> > S9564 46321
> > 156323
>
> --
>
> Dave Peterson
>