Jaslake,
Thank you for taking a stab at this.
The results that were copied did not however come out as I had hoped.
Would there be a way to generate something like this, for example, if I filter against all of the criteria in Col B, to copy the corresponding cell F2 values for each B criteria:
Real examples from worksheet:
If I filter on B = 11, F2 = 0.59163
If I filter on B = 12, F2 = 0.93764
If I filter on B = 13, F2 = 1.09873
So on and so forth.
I would love to be able to see a second sheet (CopiedResults) that has results like the above example for Cols A, B, and C.
So basically the results sheet would look like this image (these are the actual values I obtain when filtering on each of the columns):
Capture.JPG
Bookmarks