Compiling relevant data into a new list on a different worksheet

[Houseofnerd]

I am working on a macro to greatly cut down on statistical analysis for a project. The first portion (If sections 1 and 2) is complete and works fine. That part located the statistically significant values in the results and colored the cells they occupied.

The second part (If sections 3 and 4) is where I have no idea what to do. What I would like it to do is locate the colored cells, then take the category name (ie the words in the cells that correspond to the X and Y axis) and list them on another work sheet in two columns (with each color getting a different set of columns)

I have posted a sample data set to give you an idea of what the data looks like, and a general outline of what I want the final data to look like.

if anyone has some basic suggestions of approaches to try, please let me know.

Please Login or Register  to view this content.

[Houseofnerd]

Ok, I've tried retooling the code, but now I'm getting a "Statement Invalid Outside of Type Block," and I have no idea what that means.

Please Login or Register  to view this content.

[tigeravatar]

Houseofnerd,

Attached is a modified version of your sample workbook. It contains a button labelled "Update" that is assigned to the following macro:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[Houseofnerd]

Awesome, looks like it works. I can tweak it a bit to apply it to my actual data set.

Thank you kindly.