How To Loop a copy range macro until lookup cell is blank/empty

Thank Alan, no need, got it to work, appreciate your assistance. Hopefully one last question. I am able to copy just the values to clipboard, and on the Output spreadsheet 1 column of cells have a data validation drop down list setup, now if I right click and paste values, the data validation is not over ridden but if I just CTRL V, they are over ridden, any idea around this, my concern is if I am not the one doing the paste it may not be done right.