I have this excel sheet which I'm attaching. In the first column I have some numbers and the 2nd column I have a yes/no value where yes is indicated by a value of '1'. I wish to copy the values from the 1st column when the row of the 2nd column equals '1'. How do I do this? I guess with some vb script?
Can someone give me some code in vb because I'd like to learn it too?
If there is an easier way as well can you please show it to me?