Excel 2002: Can I not overwriting non blank destination cells ?

M

Mr. Low

Hi,

I understand that Copy > Paste Special > Skip Blanks allows copied blanks
cells not to overwrite non blank cells in the destination column.

How about the other way round ? i.e. to paste only the copied cells (blank
or non blank cel)l if the destination cells is blank only i.e not to
overwrites any destination cels if it is not a balnk cells.

Thanks

Low
 

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 2002: How to avoid pasting blanks ? 3
SUMIF non-blank cells? 5
Paste link only - not value 4
I copied Visible Cells Only, but it pastes only the first cell 1
MACRO - Copy several non contiguous cells. ~90% there... 0
Cell appears empty but Excel treates if as if it were not (Ctrl+Do 5
BLANK CELLS ARE NOT ACTUALLY BLANK 2
Excel 2002 : Problem in moving along blank cells 10

Top