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!
Bookmarks