zeros on linked sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I paste a row link from another sheet it puts "0" in all the empty cells is there a way to stop this and still have the cell update when I add information on the first sheet
Many Thanks from Ohio
 
Use a formula such as the following:-

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

Basically says that if the cell it is linked to is blank, then return a 'blank'
(albeit not a real one - cell is not actually empty), else return the value that
is in the cell.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



David said:
When I paste a row link from another sheet it puts "0" in all the empty cells
Click to expand...
is there a way to stop this and still have the cell update when I add
information on the first sheet?
 

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

zeros on linked sheets in 2007 2
Automatically add a value in a column 3
Linking blank cells 1
Linking Spread Sheets 1
Macro to hide rows with zero in specifc column range 2
copy rows from one Data sheet to another sheet based on cell conte 2
Returning a zero 4
linking data between sheets 1

Back
Top