macro to copy certain cells and past to another sheet.

Hi there

I have to following macro (with help from another site) that i am using to copy certain info from one sheet to another:

Please Login or Register  to view this content.

it works, but due to the fact that i have a formula that makes a "" if antoher cell is empty, i get the following output

Stephanie Products Loreal Shampoo 320
Stephanie Products Loreal Conditioner 350
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie

How can i change this macro to only get the following output

Stephanie Products Loreal Shampoo 320
Stephanie Products Loreal Conditioner 350

My previous trend can be found here http://www.mrexcel.com/forum/excel-q...worksheet.html

Thanks

Thanks

oh dear, i lost the last part of my post. with this macro i get the following output

Stephanie Products Loreal Shampoo 320
Stephanie Products Loreal Conditioner 350
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie
Stephanie

how can i edit the above macro to only get the following output?

Stephanie Products Loreal Shampoo 320
Stephanie Products Loreal Conditioner 350