Is there anything that will copy previous entry multiple times?

S

stacey

In other words I have a spreadsheet with 6000 some rows. The 1st column
either has a value or is blank. If it is blank I want it to fill in the one
above. I know about some keystrokes but that would take too long. Is there
something quicker I could create? Or is there a way to do this in Access?
 
G

Gary''s Student

Try this short macro:

Sub stacy()
n = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To n
If IsEmpty(Cells(i, 1)) Then
Cells(i, 1).FillDown
End If
Next
End Sub
 
T

T. Valko

I know about some keystrokes but that would take too long.

Is 30 seconds too long?

Select the range in question
Hit function key F5
Click: Special>Blanks>OK
Type the = sign
Press the "up" directional arrow
Hold down the CTRL key then hit ENTER

The blanks have been filled. With practice this could probably be done in
<10 seconds.
 
Top