Excel copying with link cells

G

Guest

Please can someone help me, I want to copy cells from one worksheet to
another, i have copied the cells concerned and pasted then onto the new sheet
with the paste option link cell. cells thatare blank on the original sheet
are now coming up with a 0 in the new worksheet, how do i stop the 0's being
copied over
 
G

Gord Dibben

Auz

Trap for the zeros which are unpreventable.

=IF(Sheet1!A1="","",Sheet1!A1)


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 VBA 1
How To Stop Chart Sizing With Cells? 2
Copy from worksheet to worksheet 3
Get error message about copying cells with more than 255 characte. 2
# Value error and how to ignore blank cells 2
When I link blank cell in one sheet registers as 0 for averaging 3
copying data to different Cells 1
Paste link does not work properly 1

Top