Hello again.
I want to copy only some of the rows of data from one sheet to another. I want to have a macro in sheet y
that will look at the data in sheet x and copy only those rows that have a "YES" in, say, column AA.
The macro should start looking in row 2 in sheet x and starting copying in row 2 in sheet y.
Thank you to all who have helped me so far and all who will help me in the future on my path to a docorate.
Gene
I want to copy only some of the rows of data from one sheet to another. I want to have a macro in sheet y
that will look at the data in sheet x and copy only those rows that have a "YES" in, say, column AA.
The macro should start looking in row 2 in sheet x and starting copying in row 2 in sheet y.
Thank you to all who have helped me so far and all who will help me in the future on my path to a docorate.
Gene