LinkBack URL
About LinkBacks
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!
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!
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.
There are other methods that could be used. You would have to better describe the nature of your data.
Please Login or Register to view this content.
Last edited by AlphaFrog; 04-29-2013 at 05:02 PM.
Works perfect, thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks