Ask Your Question

How to fill in blank cells in column by copying filled cell above [closed]

asked 2012-06-29 14:55:01 +0200

rudivs gravatar image

updated 2013-02-05 16:18:14 +0200

qubit gravatar image

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.

fill example

I know this is fairly trivial to do by hand, but with 34000 entries I'm looking for an easier way.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 00:04:05.748572


Try macro from this project

JohnSUN gravatar imageJohnSUN ( 2012-06-29 20:14:37 +0200 )edit

Thanks JohnSUN, this was exactly what I was looking for!

rudivs gravatar imagerudivs ( 2012-07-12 15:02:03 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-01-28 08:31:32 +0200

qubit gravatar image

(Turning @JohnSUN's comment into an answer so we can resolve this question)

Quoth JohnSUN:

Try macro from this project

edit flag offensive delete link more

Question Tools


Asked: 2012-06-29 14:55:01 +0200

Seen: 2,441 times

Last updated: Jan 28 '13