Ignore Blanks
 

I have a worksheet that I copy cells from other worksheets. Just a simple
copy/paste/link works great - unless the original cell is blank - and then it
puts a 0% in. I need it to stay blank and not to put any value if blank but
cannot figure out how to do that. I am not trying to sum or concatenate or
any other forumula, simply updating various worksheets in a workbook weekly
and have my master update from all the worksheets. I have over 57000 cells
so I really don't want to have to manually update each cell when it's blank
(not to mention I don't know since I do have valid 0's in some). Any help
is appreciated!

Ignore Blanks
 

You will need to change your formulas from:
=[MyBook.xls]Sheet1!a1

to

=IF(ISBLANK([MyBook.xls]Sheet1!a1),"",[MyBook.xls]Sheet1!a1)

--
Best Regards,

Luke M
"SEF" wrote in message
...
I have a worksheet that I copy cells from other worksheets. Just a simple
copy/paste/link works great - unless the original cell is blank - and then
it
puts a 0% in. I need it to stay blank and not to put any value if blank
but
cannot figure out how to do that. I am not trying to sum or concatenate or
any other forumula, simply updating various worksheets in a workbook
weekly
and have my master update from all the worksheets. I have over 57000
cells
so I really don't want to have to manually update each cell when it's
blank
(not to mention I don't know since I do have valid 0's in some). Any
help
is appreciated!

Ignore Blanks
 

See one reply at your earlier posting.

No need to multi-post.


Gord Dibben MS Excel MVP

On Tue, 27 Apr 2010 11:21:01 -0700, SEF
wrote:

I have a worksheet that I copy cells from other worksheets. Just a simple
copy/paste/link works great - unless the original cell is blank - and then it
puts a 0% in. I need it to stay blank and not to put any value if blank but
cannot figure out how to do that. I am not trying to sum or concatenate or
any other forumula, simply updating various worksheets in a workbook weekly
and have my master update from all the worksheets. I have over 57000 cells
so I really don't want to have to manually update each cell when it's blank
(not to mention I don't know since I do have valid 0's in some). Any help
is appreciated!