Copy Paste in the column until there a value

Hi,

In the column A, I have values with a few blanks. I need to be able to copy to the blanks, the value that was there in the cell above.
For example, if I have something like....

	A
1	aa
2
3
4	bb
5
6	cc
7	dd
8
9

I will need it to look like,

	A
1	aa
2	aa
3	aa
4	bb
5	bb
6	cc
7	dd
8	dd
9	dd

Please help. Thanks!

Please Login or Register  to view this content.

Elio Fernandes

Thanks Patel and Elio. Both codes work great!