Copying data from 1 worksheet and pasting to another skipping blan

C

Concertgoer

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
 
G

Gord Dibben

Try Data>Filter>Autofilter.

Filter for non-blanks then F5>Special>Visible cells only>OK

Copy and paste to the other sheet.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
copying cell contents from one worksheet to another (re-sorted lis 2
Copy and Paste from one sheet to another 3
How to extract email addresses from 1 worksheet to another workbook 11
copy rows from one Data sheet to another sheet based on cell conte 2
Copying and pasting to visible cells only 4
Row height changes when copying and pasting 2
Copying and Pasting Links 2

Top