set up a formula to automatically fill down from previous cell
 

I would like to know how to set up a formula that will find a blank cell in a
column and fill in that cell with the infomation (text) that is found in the
cell directly above it.

set up a formula to automatically fill down from previous cell
 

Try something like this:

Select the range of formulas interspersed with blanks

Press the [F5] key.......that's the shortcut for <edit<go to
Click [Special]......Check: Blanks......click [OK]

While the blanks are selected....
Type =
.....press the UP arrow one time
....Hold down the [Ctrl] key and press [enter]

That's it....each formerly blank cell now contains a formula referencing the
cell directly above it.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"audif" wrote:

I would like to know how to set up a formula that will find a blank cell in a
column and fill in that cell with the infomation (text) that is found in the
cell directly above it.

set up a formula to automatically fill down from previous cell
 

This should do what you want, set the for i part to the first row of data
and set the columns and it should work be what you want

Sub main()
Dim lastCell As Long
Dim myRow As Long

lastCell = Cells(Rows.Count, "A").End(xlUp).Row

For i = 2 To lastCell
myRow = i - 1
If Cells(i, 1) = "" Then Cells(i, 1) = Cells(myRow, 1)
Next

End Sub


--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"audif" wrote in message
...
I would like to know how to set up a formula that will find a blank cell in
a
column and fill in that cell with the infomation (text) that is found in
the
cell directly above it.

set up a formula to automatically fill down from previous cell
 

That is so cool....thanks, audif

"Ron Coderre" wrote:

Try something like this:

Select the range of formulas interspersed with blanks

Press the [F5] key.......that's the shortcut for <edit<go to
Click [Special]......Check: Blanks......click [OK]

While the blanks are selected....
Type =
....press the UP arrow one time
...Hold down the [Ctrl] key and press [enter]

That's it....each formerly blank cell now contains a formula referencing the
cell directly above it.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"audif" wrote:

I would like to know how to set up a formula that will find a blank cell in a
column and fill in that cell with the infomation (text) that is found in the
cell directly above it.

set up a formula to automatically fill down from previous cell
 

I'm glad I could help....(and thanks for the feedback)


***********
Regards,
Ron

XL2002, WinXP


"audif" wrote:

That is so cool....thanks, audif

"Ron Coderre" wrote:

Try something like this:

Select the range of formulas interspersed with blanks

Press the [F5] key.......that's the shortcut for <edit<go to
Click [Special]......Check: Blanks......click [OK]

While the blanks are selected....
Type =
....press the UP arrow one time
...Hold down the [Ctrl] key and press [enter]

That's it....each formerly blank cell now contains a formula referencing the
cell directly above it.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"audif" wrote:

I would like to know how to set up a formula that will find a blank cell in a
column and fill in that cell with the infomation (text) that is found in the
cell directly above it.