copy range of cells with blanks then paste without blanks

G

Guest

I have a range of cells that have values in some cells and blank in others
(actually there is a formula in all cells, but if there is no value, the
formula returns nothing but a blank cell). I want to copy that range of
cells and paste it in a column without pasting the blank cells. So the copy
range may be 40 cells, but the paste range may only be 15 or 20. How can I
paste this into the destination cells leaving no blanks? Any help would be
greatly appreciated. Thanks, Rob
 

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

copy range of cells with blanks then paste without blanks 5
Counting non blanks different from "" 4
Ignore Blanks in Data Validation 9
Eliminate blanks while copy row and transpose 11
copy a list and skipping blanks 19
sum of range containing formula in blanks 1
SUMIF & MEDIAN with blanks & text 10
Standard Deviation including blank cells 7

Top