create vertical table of specifc cells in correlation matrix

I've attached a workbook which has a large correlation matrix in tab 1. You'll see that specific cells are highlighted in green. The highlighting is due to conditional formatting which formats a cell in green only if its value is between -.20 and + .20.

I want to create a table in the second worksheet which finds the highlighted cells in the first worksheet, and lists them in a vertical manner. (see my example in the "Green Only" worksheet).

Since I'm dealing with sensitive material, I've created labels for the cells in the first worksheet using a list of three-letter words from a scrabble dictionary!

Is there a formula which can do this? I don't really care about the ordering of the table in the second worksheet, so long as it identifies the label names and corresponding correlation value.

I appreciate your help!

Please Login or Register  to view this content.

Click "RUN" to execute macro

Wow John, thank you! And thank you again!

I tided up the code ...

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

John, thanks again!