So....

I have the following worksheets: "ParaNum", "Combined Test Scripts". There's only one column in "ParaNum" that has data in it (just paragraph numbers in each cell). "Combined Test Scripts" has a merged set of test scripts in one column. Can I use a macro that incorporates the FIND ALL function? I'd like it to FIND ALL instances of each cell in "ParaNum" and then display the results in a new sheet, consecutively.

Any help would be greatly appreciated!!!!