macro

[china]

Please help!

I have rec for example

column a
123

546

789

444

I need a macro that will result : the space below of each
number must contain the same value ahead of it.

column a
123
123
546
546
789
789
444
444

Any help is greatly appreciated.
Thank you!

 

[Guest]

Are you doing this repeatedly (then you'll need want a macro) otherwise,
first selects the range with the numbers
then press f5(goto), click special, and select blank
then enter "=" and press your arrow up key,
then press Ctrl+enter.
Each of the blank cells will show what's above.

You could record a macro, do the above, and then edit the macro based on
your need to accommodate differing ranges.

Good luck,
Bert