View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sk sk is offline
external usenet poster
 
Posts: 24
Default Taking values from another cell

Thanks to everyone in advance..

I am taking values from one XL sheet and using them in another one (with a
simple "=" function). However, values that are blank in the original sheet
show up with a '0' in the new one. Is there a way for a blank to show up as a
blank? (and if the original blank cell is filled then the new cell gets
filled with that value?)

I don't know any visual basic or anything like that, and I would prefer to
avoid using macros...

Thanks again