Autofill blank cells

[nek0]

I have a data which I need to fill the cells automatically. What's happening is when exporting the data, the system does not fill the account # for each line/cell assuming the first cell is the correct account #.

Account #
900001297
blank space
40003461
blank space
blank space
900001156
blank space
blank space
blank space
blank space

Basically the cells between 900001297 & 40003461 is account # 900001297 and I need a simple macro of some kind that would fill the cells with the account number referencing the immediate account number above. The two blank cells between 40003461 & 90000156 will reference & show 40003461 and so on...

Any help is appreciated!

[Hellboy]

If you want to do so by using excel formula:

A B
900001297 =A1
=SI(A2<>"",A2,B1)
40003461 =SI(A3<>"",A3,B2)
=SI(A4<>"",A4,B3)
=SI(A5<>"",A5,B4)
900001156 =SI(A6<>"",A6,B5)
=SI(A7<>"",A7,B6)
=SI(A8<>"",A8,B7)
=SI(A9<>"",A9,B8)
=SI(A10<>"",A10,B9)



A B
900001297 900001297
900001297
40003461 40003461
40003461
40003461
900001156 900001156
900001156
900001156
900001156
900001156

If you want to use VBA, then just reply to this post

Best Regards

Phil

[nek0]

Hi Phil,

Thank you for your reply.

When I plug in the formula I get a "#name?" error in the cells. What is the =SI() formula for? I'm running Office 2k if that helps.