Hi,

Please be more specific with your question. Post an example and tell us
exactly what you want as the result

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Lversteeg" wrote in message
...
I was wondering if anyone could help me.

I have on one sheet a product selector for my sales team. I have added a
column where they can put an "x" into if they would like to quote that
product to a client. I have created another sheet called "Quote" where the
prodcut details are automatically updated from the "Product Selector".
However if they choose the products listed in ROW 1, 5 and 7 they are
copied
the same way to the quote with blank lines in between. How can I make sure
that they are copied over but without the blank lines?

I hope this makes sense.
Thanks