A macro I'm writing needs to gather values from a column and put them in a new sheet; however, many of the cells in the column have several values in a cell, separated by a soft return.
I need it to put each value of the soft-returned cell into its own row in the new spreadsheet.
How do I program for VB to copy the first value in the cell and then during the next pass to take the second value in the cell? Or is there a way to split it in the new sheet?
Thanks!
Bookmarks