Try this:

Select your entire data range
<Edit<Go to
Click the [Special Cells] button
Check: Blanks
Click the [OK] button

Then...while those blanks are selected...
Type =
then press the UP ARROW key one time
Then..holding down the [Ctrl] and [Shift] keys...press the [Enter] key

That should cause every blank cell to reflect the first available value
above it.

Note: to "hard code" those values...
Select the entire data range
<Edit<Copy
<Edit<Paste Special
Check: Values
Click the [OK] button

Does that help?

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

XL2002, WinXP-Pro


"Lolly" wrote:

Hi,
all

Here is a example.
I have three columns in excel.There are some blank cells and rows.
A B C
SMH SMHP CPR


MDR



SLK
CPD DHG STG
STG



Here is how it should look after filling up the blank columns
Col A Col B Col C
SMH SMHP CPR
SMH SMHP CPR
SMH SMHP MDR
SMH SMHP MDR
SMH SMHP MDR
SMH SMHP SLK
CPD DHG STG
CPD DHG STG


Right now I am doing it manually. Is there a way I can do it by writing some
VBA code or macros

Any help would be highly appreciated?
--
Kittie