Change of plans, I would like to auto generate sheet1 to copy selected text from column A all the way down until there is a new text and then copy the new text all the way down until there is again another new text. so the formula should read something like = IF CELL A 1 IS NOT BLANK COPY IT UNTIL A IS NO LONGER BLANK WHEN THAT OCCURS COPY NEW TEXT UNTIL IT IS INTERRUPTED BY NEW TEXT???
Solved by F. B. in 16 mins