PDA

View Full Version : Need help creating macro in excel 2000



decipherus
14-11-2008, 02:26 PM
Hi Everyone,

I'm new but I've been browsing this forum and it has been very informative/helpful in the past. Anyhow, I need the assistance of Excel experts please. Here's the problem I'm encountering. Basically, I'm running a report and I have several blank cells that I need to populate with data from the previous cell. I tried recording a macro but I could never get it to work (data looks like this).

A B
1 Name Code
2 John 1
3 1
4 Jane 2
5 Jody 3
6 3
7 3
8 Juan 4

Want to be able to create a macro or manipulate the VB script to makes the data appear like this:

A B
1 Name Code
2 John 1
3 John 1
4 Jane 2
5 Jody 3
6 Jody 3
7 Jody 3
8 Juan 4

Any help will be greatly appreciated. Thanks everyone!!!!
BTW - I'm using Excel 2000 so precise procedures or sample VB code would be helpful.

zcc
14-11-2008, 04:21 PM
have a look at this...
http://www.ozgrid.com/Excel/excel-fill-blank-cells.htm

decipherus
15-11-2008, 12:24 PM
have a look at this...
http://www.ozgrid.com/Excel/excel-fill-blank-cells.htm

@ZCC

My sincerest thanks - tweaked it a little but it was exactly what I needed.
Great link!!!