I currently copy and paste cell information contained in specific rows from one worksheet to another based on whether or not a specific cell in the row contains any data. For example; I will copy cells A10,B10,C10,D10,H10,Q10, and R10 only if Q10 has data entered. Any formulas to automate this process??