I need to copy a cell value down a column until there is a non-empty cell. When such a cell is encountered, its value needs to be copied down until another non-empty cell is found. In column A of the following example, the space under 'tao' should be filled with copies of 'tao', the space under solitarius should be filled with 'solitarius', etc.
I know this is fairly trivial to do by hand, but with 34000 entries I'm looking for an easier way.
(Turning @JohnSUN's comment into an answer so we can resolve this question)
Quoth JohnSUN:
Try macro from this project
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-06-29 14:55:01 +0200
Seen: 279 times
Last updated: Jan 28
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Try macro from this project
JohnSUN ( 2012-06-29 20:14:37 +0200 )editThanks JohnSUN, this was exactly what I was looking for!
rudivs ( 2012-07-12 15:02:03 +0200 )edit