Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Colors | Excel Worksheet Functions | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |