Hi,

This is probably a really newbie question, but I'm not even sure where to start. I have an Excel worksheet with a list of many variables under subheadings. Lets call these subheadings A, B, C, D, E and F. These alphabetical subheadings have binary values in a column (either 0 or 1) based on the alphabetical subheading (except for the last column). See Picture for better illustration:

http://imgur.com/9qDNy.jpg

Now what I want to do is to be able to essentially copy and paste values that correspond to a certain criteria (I imagine I would need to use an IF command or something similar?) into a separate worksheet. So using the example above lets say I want, for each row:

1) IF (C=0) AND (E=1) then copy the values in A, B and F, as well as C and E (of that row) into their own row in a new worksheet
2) IF (C=1) AND (E=0) then copy the values in A, B and F, as well as C and E (of that row)into their own row in a new worksheet
3) IF (C=1) AND (E=1) then copy the values in A, B and F, as well as C and E (of that row) into their own row in a new worksheet
4) IF (C=0) AND (E=0) then IGNORE

So in the above image example, the new worksheets would look like:

http://imgur.com/t2jwh.jpg

As you can see, the values that WERE in column D in the original, are nowhere in the new worksheets, and they are sorted according to those criteria. Row 5 is also not included anywhere, as it had C=0 and E=0.

If anyone can help it would be greatly appreciated.

b1177