Hello world,

OK i was trying the copy and paste thing yesterday but i think its beyond my abilities, anyway i think there is a better way to do it.
If you view the attached file you will see column H,I,J contain Y in some cases. what i want to do is, create a loop that will run down trough column H first and for each instance of "Y" cut and copy that entire row to a new sheet. Again do the same for column I and the same for J.
therefore i will have 4 sheets. the original, 1 for column H,1 for column I and 1 for column J.
I am a beginer to VBA and dont really have clue so any pointers would be great.
thanks in advance.