Hello, I have 8 columns of data that extends to over 1000 rows. One column
contains different patterns. I would like to copy the data in the cells of
two columns on the same row for all the instances of the same pattern to
another worksheet. I would then have a worksheet for each pattern. I may not
have described this clearly so there an example below. Many thanks, David

Before

Column C Column F Column G
Cross 5.32 17.6
Lines 8.67 12.4
Circles 3.44 67.5
Lines 5.67 45.3
Squares 8.42 4.56
Lines 8.99 12.7
etc...

After - for the Lines pattern (another worksheet)

Column A Column B
8.67 12.4
5.67 45.3
8.99 12.7