Copy Range but Skip blank rows Q Options


S

Sean

How do I copy (values) a range of cells that have blank rows in
between to another range without the blank rows. I thought it was
copy-
paste special values-skip blanks, but when I do I still see the blank
rows

eg Copy values in A1:A5 (blank rows are in A2 & A4) to M1:M3


Thanks
 
Ad

Advertisements


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

numbering rows, but skipping blanks 13
Skip blanks 6
skipping blanks? 3
skipping blank spaces 1
Skipping Columns/Rows 2
Maximum Rows Q 2
reference while skipping rows 3
Pressing Enter to skip rows 4

Top