How can I loop through rows in Excel and transpose them until a hyperlink is reached?
===

I saw a similar question (http://stackoverflow.com/questions/10536611/excel-loop-through-list-transpose-and-create-a-matrix-based-on-cell-content) that asks for something similar to what I need, except using a KEY. I don't have any specific textual key, but I need to break it up based on text with a hyperlink. Help is much appreciated, thanks!
