Paste Link

  • Thread starter Thread starter Marie
  • Start date Start date
M

Marie

I am paste linking one worksheet of information into
another worksheet within the same workbook. However, the
empty cells that carry over become filled with zero's. I
have tried using the Find and Replace feature. However,
not only does it remove the zeros, but it also removes
other content that is plain text.

Is there another solution to my problem that will be fast
and efficient? Or will I need to delete one cell at a
time???
 
Thanks, Arvi! But, I have one problem - here is the
formula I created =IF(A4:R42=0,??,A4:R42)- what do I use
to delete items that are TRUE (in this case a 0)? I tried
leaving the TRUE value empty, but that didn't work.
 
Hi

First, in Excel 0 correspond to FALSE and 1 to TRUE

And second - maybe you explayn what do you want to do - this formula doesn't
work anyway.
 
You must log in or register to reply here.

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

Linking blank cells 1
Paste Values in linked Cells Only 4
Copying linked sheet 2
Linking Cells 7
... I would like to link conditional formating to linked workbooks 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
"Replace all" changes formatting 5
Sharing workbooks limitations - Merged Cells 12

Back
Top