Looking to create a macro that will skip blank cells in a column, find data cells

[crayzwalz]

Looking to create a macro that will skip blank cells in a column, find data cells, then copy the data cells and paste it 1 row under. I'm stuck on finding a way so it skips only to cells of the column that have data inputted in them. Thanks!

[AlphaFrog]

As an example, this loops through all cells in column A that have data (constants and not from formulas). It copies each cell's value to the cell just below it.

Please Login or Register  to view this content.

There are other methods that could be used. You would have to better describe the nature of your data.

[crayzwalz]

Works perfect, thanks for the help!