Hello,

I have a spreadsheet with two worksheets. In the first worksheet, in the first column, I have text but not in every cell of that column. my cell range in that A column is A5 to A244. I would like to search that column starting at cell A5 and if the cell is found to be blank then go search the next cell and so on and so on until i find text. when i find text i would like that text to be copied to a separate worksheet starting in the first column, first row cell a1. then i would like to go back and keep searching down until A244 on the worksheet and repeat this process over and over so that all text found is placed in my second worksheet column "A' so that cells a1,a2,a3,a4,a5,a6, etc. are filled. Thanks for any assistance provided.