Hello all
I am cleaning my data in stages. For my first stage, I want to eliminate all the rows where my survey participant did not answer any questions (meaning he or she wasn't truly a participant). I will know this if columns F through BK are completely empty. So what is need is this: Starting with row 3 in sheet x, I want to copy that row into sheet y as long as columns F through BK are not COMPLETELY EMPTY. I want to do this for every row until the last.
Thank you in advance for helping me with my PhD.
Gene
I am cleaning my data in stages. For my first stage, I want to eliminate all the rows where my survey participant did not answer any questions (meaning he or she wasn't truly a participant). I will know this if columns F through BK are completely empty. So what is need is this: Starting with row 3 in sheet x, I want to copy that row into sheet y as long as columns F through BK are not COMPLETELY EMPTY. I want to do this for every row until the last.
Thank you in advance for helping me with my PhD.
Gene