Hi, basically I have a sheet that contains a number of rows with text in, the end cell on each row does not always contain some text. So what I'm looking to do is for the cells that do contain text, copy that entire row into another sheet?
How would I go about doing this?