macro to auto copy and fill down data in column

[kks]

I want to highlight a column that has data in various cells and automatically
fill the blank cells down until new data is found at which point the new data
is automatically copied and filled down etc. I am using Excel 2003. How do I
do this?

 

[KARL DEWEY]

This newsgroup is for Access, relational database.
But here is the answer but no need for macro --
Add a new column to left of the column (existing column A here) , add a row
under, and enter this
formula in A2 -- =IF(B2="", A1, B2)
A B C
1
2 123 abc
3 cab
4 gef
5 124 ced
6 rad
Then drag to fill column A.