Macro to copy cell content to a single column

Dear all,

I was wondering if you would be able to help me, as I am no computer expert!

I have Excel Sheets that contain a number of values scattered throughout the page, and I have been copying and pasting them manually into a single column. The order of this values in the single column is not relevant.

The position in which the values are originally varies every time and so does the number of values.

I wonder if it is possible to create a macro that could do this for me?

I work with Excel 2008 12.3.6 for Mac

Thanks a lot in advance!!

Lorean

Thank you very much! works beautifully

As an option