I currently have 4 rows of data that I have an If then statement which
creates data, with empty cells between them. I am looking for a way to paste
that info into another worksheet in the same workbook, however I want it to
list the item s one after another, and not paste the blanks. Please hep
Thanks so muh