Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,118
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 93
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,118
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Colors whispagirl Excel Worksheet Functions 6 December 28th 06 04:02 AM
Cell References [email protected] Excel Discussion (Misc queries) 2 November 16th 06 12:37 AM
Using an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 06:12 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM


All times are GMT +1. The time now is 06:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"