macro to autofill data in the same column

[ockyoz]

Hi guys, often I have data like the following:

rose





Lilly





tulip

and I need to autofill the cells in the column (got thousands of names and the position of the names is always different) so I have been double clicking at the lower right corner of the cell every time but it's time consuming. Could a macro help me out??
Cheers

 

[ockyoz]

My bad, I did only test it with the 3 words. Just tested it with a different spreadsheet and works a treat!! thanks heaps!

 

[Akuini]

My bad, I did only test it with the 3 words. Just tested it with a different spreadsheet and works a treat!! thanks heaps!

You're welcome & thanks for replying