|
Posted to microsoft.public.excel.programming
|
|
|
Copy cell to empty cells below.
See
http://www.contextures.com/xlDataEntry02.html
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
wrote in message ...
Hello folks.
My spreadsheet has 22000 rows. The data import was from an html
report from another app.
Column A is as shown, column B has data in cells 1 through 9. So
column B is no problem. When I apply a autofilter on the sheet column
A most of the time shows blanks. I need to fill in the blanks with
the preceeding nonblank. If it is nonblank it should skip to the next
line and try again. I'm familiar with if then else and for next
loops but not the MS Excel way of doing things. Syntax errors
galore. My other problem is that Im not sure where to put this
formula / script.
I want this:
A
1 blah
2
3
4 blah blah
5
6
7 hohum
8
9
To Turn into this:
A
1 blah
2 blah
3 blah
4 blah blah
5 blah blah
6 blah blah
7 hohum
8 hohum
9 hohum
Any help is greatly appreciated.
|